/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : 127.0.0.1:3306
 Source Schema         : back

 Target Server Type    : MySQL
 Target Server Version : 50726
 File Encoding         : 65001

 Date: 19/07/2019 11:28:59
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for ACT_EVT_LOG
-- ----------------------------
DROP TABLE IF EXISTS `ACT_EVT_LOG`;
CREATE TABLE `ACT_EVT_LOG` (
  `LOG_NR_` bigint(20) NOT NULL AUTO_INCREMENT,
  `TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TIME_STAMP_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `DATA_` longblob,
  `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL,
  `IS_PROCESSED_` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`LOG_NR_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_GE_BYTEARRAY
-- ----------------------------
DROP TABLE IF EXISTS `ACT_GE_BYTEARRAY`;
CREATE TABLE `ACT_GE_BYTEARRAY` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `BYTES_` longblob,
  `GENERATED_` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_FK_BYTEARR_DEPL` (`DEPLOYMENT_ID_`),
  CONSTRAINT `ACT_FK_BYTEARR_DEPL` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `ACT_RE_DEPLOYMENT` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_GE_PROPERTY
-- ----------------------------
DROP TABLE IF EXISTS `ACT_GE_PROPERTY`;
CREATE TABLE `ACT_GE_PROPERTY` (
  `NAME_` varchar(64) COLLATE utf8_bin NOT NULL,
  `VALUE_` varchar(300) COLLATE utf8_bin DEFAULT NULL,
  `REV_` int(11) DEFAULT NULL,
  PRIMARY KEY (`NAME_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of ACT_GE_PROPERTY
-- ----------------------------
BEGIN;
INSERT INTO `ACT_GE_PROPERTY` VALUES ('next.dbid', '1', 1);
INSERT INTO `ACT_GE_PROPERTY` VALUES ('schema.history', 'create(5.22.0.0)', 1);
INSERT INTO `ACT_GE_PROPERTY` VALUES ('schema.version', '5.22.0.0', 1);
COMMIT;

-- ----------------------------
-- Table structure for ACT_HI_ACTINST
-- ----------------------------
DROP TABLE IF EXISTS `ACT_HI_ACTINST`;
CREATE TABLE `ACT_HI_ACTINST` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `ACT_ID_` varchar(255) COLLATE utf8_bin NOT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `CALL_PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `ACT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `ACT_TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `START_TIME_` datetime(3) NOT NULL,
  `END_TIME_` datetime(3) DEFAULT NULL,
  `DURATION_` bigint(20) DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_HI_ACT_INST_START` (`START_TIME_`),
  KEY `ACT_IDX_HI_ACT_INST_END` (`END_TIME_`),
  KEY `ACT_IDX_HI_ACT_INST_PROCINST` (`PROC_INST_ID_`,`ACT_ID_`),
  KEY `ACT_IDX_HI_ACT_INST_EXEC` (`EXECUTION_ID_`,`ACT_ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_HI_ATTACHMENT
-- ----------------------------
DROP TABLE IF EXISTS `ACT_HI_ATTACHMENT`;
CREATE TABLE `ACT_HI_ATTACHMENT` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `URL_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `CONTENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TIME_` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_HI_COMMENT
-- ----------------------------
DROP TABLE IF EXISTS `ACT_HI_COMMENT`;
CREATE TABLE `ACT_HI_COMMENT` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TIME_` datetime(3) NOT NULL,
  `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `ACTION_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `MESSAGE_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `FULL_MSG_` longblob,
  PRIMARY KEY (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_HI_DETAIL
-- ----------------------------
DROP TABLE IF EXISTS `ACT_HI_DETAIL`;
CREATE TABLE `ACT_HI_DETAIL` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `ACT_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin NOT NULL,
  `VAR_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `REV_` int(11) DEFAULT NULL,
  `TIME_` datetime(3) NOT NULL,
  `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `DOUBLE_` double DEFAULT NULL,
  `LONG_` bigint(20) DEFAULT NULL,
  `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_HI_DETAIL_PROC_INST` (`PROC_INST_ID_`),
  KEY `ACT_IDX_HI_DETAIL_ACT_INST` (`ACT_INST_ID_`),
  KEY `ACT_IDX_HI_DETAIL_TIME` (`TIME_`),
  KEY `ACT_IDX_HI_DETAIL_NAME` (`NAME_`),
  KEY `ACT_IDX_HI_DETAIL_TASK_ID` (`TASK_ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_HI_IDENTITYLINK
-- ----------------------------
DROP TABLE IF EXISTS `ACT_HI_IDENTITYLINK`;
CREATE TABLE `ACT_HI_IDENTITYLINK` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_HI_IDENT_LNK_USER` (`USER_ID_`),
  KEY `ACT_IDX_HI_IDENT_LNK_TASK` (`TASK_ID_`),
  KEY `ACT_IDX_HI_IDENT_LNK_PROCINST` (`PROC_INST_ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_HI_PROCINST
-- ----------------------------
DROP TABLE IF EXISTS `ACT_HI_PROCINST`;
CREATE TABLE `ACT_HI_PROCINST` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `BUSINESS_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `START_TIME_` datetime(3) NOT NULL,
  `END_TIME_` datetime(3) DEFAULT NULL,
  `DURATION_` bigint(20) DEFAULT NULL,
  `START_USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `START_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `END_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `SUPER_PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  UNIQUE KEY `PROC_INST_ID_` (`PROC_INST_ID_`),
  KEY `ACT_IDX_HI_PRO_INST_END` (`END_TIME_`),
  KEY `ACT_IDX_HI_PRO_I_BUSKEY` (`BUSINESS_KEY_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_HI_TASKINST
-- ----------------------------
DROP TABLE IF EXISTS `ACT_HI_TASKINST`;
CREATE TABLE `ACT_HI_TASKINST` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TASK_DEF_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PARENT_TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `START_TIME_` datetime(3) NOT NULL,
  `CLAIM_TIME_` datetime(3) DEFAULT NULL,
  `END_TIME_` datetime(3) DEFAULT NULL,
  `DURATION_` bigint(20) DEFAULT NULL,
  `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `PRIORITY_` int(11) DEFAULT NULL,
  `DUE_DATE_` datetime(3) DEFAULT NULL,
  `FORM_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_HI_TASK_INST_PROCINST` (`PROC_INST_ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_HI_VARINST
-- ----------------------------
DROP TABLE IF EXISTS `ACT_HI_VARINST`;
CREATE TABLE `ACT_HI_VARINST` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin NOT NULL,
  `VAR_TYPE_` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `REV_` int(11) DEFAULT NULL,
  `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `DOUBLE_` double DEFAULT NULL,
  `LONG_` bigint(20) DEFAULT NULL,
  `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `CREATE_TIME_` datetime(3) DEFAULT NULL,
  `LAST_UPDATED_TIME_` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_HI_PROCVAR_PROC_INST` (`PROC_INST_ID_`),
  KEY `ACT_IDX_HI_PROCVAR_NAME_TYPE` (`NAME_`,`VAR_TYPE_`),
  KEY `ACT_IDX_HI_PROCVAR_TASK_ID` (`TASK_ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_ID_GROUP
-- ----------------------------
DROP TABLE IF EXISTS `ACT_ID_GROUP`;
CREATE TABLE `ACT_ID_GROUP` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_ID_INFO
-- ----------------------------
DROP TABLE IF EXISTS `ACT_ID_INFO`;
CREATE TABLE `ACT_ID_INFO` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `USER_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `VALUE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PASSWORD_` longblob,
  `PARENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_ID_MEMBERSHIP
-- ----------------------------
DROP TABLE IF EXISTS `ACT_ID_MEMBERSHIP`;
CREATE TABLE `ACT_ID_MEMBERSHIP` (
  `USER_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `GROUP_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`USER_ID_`,`GROUP_ID_`),
  KEY `ACT_FK_MEMB_GROUP` (`GROUP_ID_`),
  CONSTRAINT `ACT_FK_MEMB_GROUP` FOREIGN KEY (`GROUP_ID_`) REFERENCES `ACT_ID_GROUP` (`ID_`),
  CONSTRAINT `ACT_FK_MEMB_USER` FOREIGN KEY (`USER_ID_`) REFERENCES `ACT_ID_USER` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_ID_USER
-- ----------------------------
DROP TABLE IF EXISTS `ACT_ID_USER`;
CREATE TABLE `ACT_ID_USER` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `FIRST_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `LAST_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `EMAIL_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PWD_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PICTURE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_PROCDEF_INFO
-- ----------------------------
DROP TABLE IF EXISTS `ACT_PROCDEF_INFO`;
CREATE TABLE `ACT_PROCDEF_INFO` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `INFO_JSON_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  UNIQUE KEY `ACT_UNIQ_INFO_PROCDEF` (`PROC_DEF_ID_`),
  KEY `ACT_IDX_INFO_PROCDEF` (`PROC_DEF_ID_`),
  KEY `ACT_FK_INFO_JSON_BA` (`INFO_JSON_ID_`),
  CONSTRAINT `ACT_FK_INFO_JSON_BA` FOREIGN KEY (`INFO_JSON_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`),
  CONSTRAINT `ACT_FK_INFO_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RE_DEPLOYMENT
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RE_DEPLOYMENT`;
CREATE TABLE `ACT_RE_DEPLOYMENT` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  `DEPLOY_TIME_` timestamp(3) NULL DEFAULT NULL,
  PRIMARY KEY (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RE_MODEL
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RE_MODEL`;
CREATE TABLE `ACT_RE_MODEL` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
  `LAST_UPDATE_TIME_` timestamp(3) NULL DEFAULT NULL,
  `VERSION_` int(11) DEFAULT NULL,
  `META_INFO_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EDITOR_SOURCE_VALUE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EDITOR_SOURCE_EXTRA_VALUE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`),
  KEY `ACT_FK_MODEL_SOURCE` (`EDITOR_SOURCE_VALUE_ID_`),
  KEY `ACT_FK_MODEL_SOURCE_EXTRA` (`EDITOR_SOURCE_EXTRA_VALUE_ID_`),
  KEY `ACT_FK_MODEL_DEPLOYMENT` (`DEPLOYMENT_ID_`),
  CONSTRAINT `ACT_FK_MODEL_DEPLOYMENT` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `ACT_RE_DEPLOYMENT` (`ID_`),
  CONSTRAINT `ACT_FK_MODEL_SOURCE` FOREIGN KEY (`EDITOR_SOURCE_VALUE_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`),
  CONSTRAINT `ACT_FK_MODEL_SOURCE_EXTRA` FOREIGN KEY (`EDITOR_SOURCE_EXTRA_VALUE_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RE_PROCDEF
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RE_PROCDEF`;
CREATE TABLE `ACT_RE_PROCDEF` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `KEY_` varchar(255) COLLATE utf8_bin NOT NULL,
  `VERSION_` int(11) NOT NULL,
  `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `RESOURCE_NAME_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `DGRM_RESOURCE_NAME_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `HAS_START_FORM_KEY_` tinyint(4) DEFAULT NULL,
  `HAS_GRAPHICAL_NOTATION_` tinyint(4) DEFAULT NULL,
  `SUSPENSION_STATE_` int(11) DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`),
  UNIQUE KEY `ACT_UNIQ_PROCDEF` (`KEY_`,`VERSION_`,`TENANT_ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RU_EVENT_SUBSCR
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RU_EVENT_SUBSCR`;
CREATE TABLE `ACT_RU_EVENT_SUBSCR` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `EVENT_TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  `EVENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `ACTIVITY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `CONFIGURATION_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `CREATED_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_EVENT_SUBSCR_CONFIG_` (`CONFIGURATION_`),
  KEY `ACT_FK_EVENT_EXEC` (`EXECUTION_ID_`),
  CONSTRAINT `ACT_FK_EVENT_EXEC` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RU_EXECUTION
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RU_EXECUTION`;
CREATE TABLE `ACT_RU_EXECUTION` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `BUSINESS_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PARENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `SUPER_EXEC_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `IS_ACTIVE_` tinyint(4) DEFAULT NULL,
  `IS_CONCURRENT_` tinyint(4) DEFAULT NULL,
  `IS_SCOPE_` tinyint(4) DEFAULT NULL,
  `IS_EVENT_SCOPE_` tinyint(4) DEFAULT NULL,
  `SUSPENSION_STATE_` int(11) DEFAULT NULL,
  `CACHED_ENT_STATE_` int(11) DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_EXEC_BUSKEY` (`BUSINESS_KEY_`),
  KEY `ACT_FK_EXE_PROCINST` (`PROC_INST_ID_`),
  KEY `ACT_FK_EXE_PARENT` (`PARENT_ID_`),
  KEY `ACT_FK_EXE_SUPER` (`SUPER_EXEC_`),
  KEY `ACT_FK_EXE_PROCDEF` (`PROC_DEF_ID_`),
  CONSTRAINT `ACT_FK_EXE_PARENT` FOREIGN KEY (`PARENT_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`),
  CONSTRAINT `ACT_FK_EXE_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`),
  CONSTRAINT `ACT_FK_EXE_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `ACT_FK_EXE_SUPER` FOREIGN KEY (`SUPER_EXEC_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RU_IDENTITYLINK
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RU_IDENTITYLINK`;
CREATE TABLE `ACT_RU_IDENTITYLINK` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_IDENT_LNK_USER` (`USER_ID_`),
  KEY `ACT_IDX_IDENT_LNK_GROUP` (`GROUP_ID_`),
  KEY `ACT_IDX_ATHRZ_PROCEDEF` (`PROC_DEF_ID_`),
  KEY `ACT_FK_TSKASS_TASK` (`TASK_ID_`),
  KEY `ACT_FK_IDL_PROCINST` (`PROC_INST_ID_`),
  CONSTRAINT `ACT_FK_ATHRZ_PROCEDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`),
  CONSTRAINT `ACT_FK_IDL_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`),
  CONSTRAINT `ACT_FK_TSKASS_TASK` FOREIGN KEY (`TASK_ID_`) REFERENCES `ACT_RU_TASK` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RU_JOB
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RU_JOB`;
CREATE TABLE `ACT_RU_JOB` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL,
  `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `EXCLUSIVE_` tinyint(1) DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `RETRIES_` int(11) DEFAULT NULL,
  `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `DUEDATE_` timestamp(3) NULL DEFAULT NULL,
  `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`),
  KEY `ACT_FK_JOB_EXCEPTION` (`EXCEPTION_STACK_ID_`),
  CONSTRAINT `ACT_FK_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RU_TASK
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RU_TASK`;
CREATE TABLE `ACT_RU_TASK` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PARENT_TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TASK_DEF_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `DELEGATION_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PRIORITY_` int(11) DEFAULT NULL,
  `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
  `DUE_DATE_` datetime(3) DEFAULT NULL,
  `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `SUSPENSION_STATE_` int(11) DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  `FORM_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_TASK_CREATE` (`CREATE_TIME_`),
  KEY `ACT_FK_TASK_EXE` (`EXECUTION_ID_`),
  KEY `ACT_FK_TASK_PROCINST` (`PROC_INST_ID_`),
  KEY `ACT_FK_TASK_PROCDEF` (`PROC_DEF_ID_`),
  CONSTRAINT `ACT_FK_TASK_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`),
  CONSTRAINT `ACT_FK_TASK_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`),
  CONSTRAINT `ACT_FK_TASK_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RU_VARIABLE
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RU_VARIABLE`;
CREATE TABLE `ACT_RU_VARIABLE` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin NOT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `DOUBLE_` double DEFAULT NULL,
  `LONG_` bigint(20) DEFAULT NULL,
  `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_VARIABLE_TASK_ID` (`TASK_ID_`),
  KEY `ACT_FK_VAR_EXE` (`EXECUTION_ID_`),
  KEY `ACT_FK_VAR_PROCINST` (`PROC_INST_ID_`),
  KEY `ACT_FK_VAR_BYTEARRAY` (`BYTEARRAY_ID_`),
  CONSTRAINT `ACT_FK_VAR_BYTEARRAY` FOREIGN KEY (`BYTEARRAY_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`),
  CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`),
  CONSTRAINT `ACT_FK_VAR_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for qrtz_blob_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_blob_triggers`;
CREATE TABLE `qrtz_blob_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `BLOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `QRTZ_BLOB_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for qrtz_calendars
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_calendars`;
CREATE TABLE `qrtz_calendars` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `CALENDAR_NAME` varchar(200) NOT NULL,
  `CALENDAR` blob NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for qrtz_cron_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_cron_triggers`;
CREATE TABLE `qrtz_cron_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `CRON_EXPRESSION` varchar(200) NOT NULL,
  `TIME_ZONE_ID` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `QRTZ_CRON_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for qrtz_fired_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_fired_triggers`;
CREATE TABLE `qrtz_fired_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `ENTRY_ID` varchar(95) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `FIRED_TIME` bigint(13) NOT NULL,
  `SCHED_TIME` bigint(13) NOT NULL,
  `PRIORITY` int(11) NOT NULL,
  `STATE` varchar(16) NOT NULL,
  `JOB_NAME` varchar(200) DEFAULT NULL,
  `JOB_GROUP` varchar(200) DEFAULT NULL,
  `IS_NONCONCURRENT` varchar(1) DEFAULT NULL,
  `REQUESTS_RECOVERY` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for qrtz_job_details
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_job_details`;
CREATE TABLE `qrtz_job_details` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `JOB_CLASS_NAME` varchar(250) NOT NULL,
  `IS_DURABLE` varchar(1) NOT NULL,
  `IS_NONCONCURRENT` varchar(1) NOT NULL,
  `IS_UPDATE_DATA` varchar(1) NOT NULL,
  `REQUESTS_RECOVERY` varchar(1) NOT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for qrtz_locks
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_locks`;
CREATE TABLE `qrtz_locks` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `LOCK_NAME` varchar(40) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of qrtz_locks
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_locks` VALUES ('quartzScheduler', 'TRIGGER_ACCESS');
COMMIT;

-- ----------------------------
-- Table structure for qrtz_paused_trigger_grps
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`;
CREATE TABLE `qrtz_paused_trigger_grps` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for qrtz_scheduler_state
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_scheduler_state`;
CREATE TABLE `qrtz_scheduler_state` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `LAST_CHECKIN_TIME` bigint(13) NOT NULL,
  `CHECKIN_INTERVAL` bigint(13) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for qrtz_simple_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simple_triggers`;
CREATE TABLE `qrtz_simple_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `REPEAT_COUNT` bigint(7) NOT NULL,
  `REPEAT_INTERVAL` bigint(12) NOT NULL,
  `TIMES_TRIGGERED` bigint(10) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `QRTZ_SIMPLE_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for qrtz_simprop_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simprop_triggers`;
CREATE TABLE `qrtz_simprop_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `STR_PROP_1` varchar(512) DEFAULT NULL,
  `STR_PROP_2` varchar(512) DEFAULT NULL,
  `STR_PROP_3` varchar(512) DEFAULT NULL,
  `INT_PROP_1` int(11) DEFAULT NULL,
  `INT_PROP_2` int(11) DEFAULT NULL,
  `LONG_PROP_1` bigint(20) DEFAULT NULL,
  `LONG_PROP_2` bigint(20) DEFAULT NULL,
  `DEC_PROP_1` decimal(13,4) DEFAULT NULL,
  `DEC_PROP_2` decimal(13,4) DEFAULT NULL,
  `BOOL_PROP_1` varchar(1) DEFAULT NULL,
  `BOOL_PROP_2` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `QRTZ_SIMPROP_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for qrtz_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_triggers`;
CREATE TABLE `qrtz_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PREV_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PRIORITY` int(11) DEFAULT NULL,
  `TRIGGER_STATE` varchar(16) NOT NULL,
  `TRIGGER_TYPE` varchar(8) NOT NULL,
  `START_TIME` bigint(13) NOT NULL,
  `END_TIME` bigint(13) DEFAULT NULL,
  `CALENDAR_NAME` varchar(200) DEFAULT NULL,
  `MISFIRE_INSTR` smallint(2) DEFAULT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `SCHED_NAME` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  CONSTRAINT `QRTZ_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for t_act_business
-- ----------------------------
DROP TABLE IF EXISTS `t_act_business`;
CREATE TABLE `t_act_business` (
  `id` varchar(255) NOT NULL COMMENT '主键id',
  `proc_def_id` varchar(255) DEFAULT NULL COMMENT '流程定义id',
  `proc_inst_id` varchar(255) DEFAULT NULL COMMENT '流程实例id',
  `result` int(11) DEFAULT NULL COMMENT '结果状态 0未提交默认 1处理中 2通过 3驳回',
  `status` int(11) DEFAULT NULL COMMENT '状态 0草稿默认 1处理中 2结束',
  `table_id` varchar(255) DEFAULT NULL COMMENT '关联表id',
  `title` varchar(255) DEFAULT NULL COMMENT '申请标题',
  `user_id` varchar(255) DEFAULT NULL COMMENT '创建用户id',
  `apply_time` datetime DEFAULT NULL COMMENT '提交申请时间',
  `is_history` bit(1) DEFAULT NULL COMMENT '历史标记',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_flag` int(11) DEFAULT NULL COMMENT '删除标记',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='业务申请表';

-- ----------------------------
-- Table structure for t_act_category
-- ----------------------------
DROP TABLE IF EXISTS `t_act_category`;
CREATE TABLE `t_act_category` (
  `id` varchar(255) NOT NULL COMMENT '主键id',
  `is_parent` bit(1) DEFAULT NULL COMMENT '是否为父节点(含子节点) 默认false',
  `parent_id` varchar(255) DEFAULT NULL COMMENT '父id',
  `sort_order` decimal(10,2) DEFAULT NULL COMMENT '排序值',
  `status` int(11) DEFAULT NULL COMMENT '是否启用 0启用 -1禁用',
  `title` varchar(255) DEFAULT NULL COMMENT '分类名称',
  `type` int(11) DEFAULT NULL COMMENT '类型 0分组 1分类',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_flag` int(11) DEFAULT NULL COMMENT '删除标记',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='流程分类表';

-- ----------------------------
-- Table structure for t_act_model
-- ----------------------------
DROP TABLE IF EXISTS `t_act_model`;
CREATE TABLE `t_act_model` (
  `id` varchar(255) NOT NULL COMMENT '主键id',
  `name` varchar(255) DEFAULT NULL COMMENT '模型名称',
  `model_key` varchar(255) DEFAULT NULL COMMENT '标识',
  `description` varchar(255) DEFAULT NULL COMMENT '描述/备注',
  `version` int(11) DEFAULT NULL COMMENT '版本',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_flag` int(11) DEFAULT NULL COMMENT '删除标记',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='模型表';

-- ----------------------------
-- Table structure for t_act_node
-- ----------------------------
DROP TABLE IF EXISTS `t_act_node`;
CREATE TABLE `t_act_node` (
  `id` varchar(255) NOT NULL COMMENT '主键id',
  `node_id` varchar(255) DEFAULT NULL COMMENT '节点id',
  `type` varchar(255) DEFAULT NULL COMMENT '节点关联类型 0角色 1用户 2部门',
  `relate_id` varchar(255) DEFAULT NULL COMMENT '关联其他表id',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_flag` int(11) DEFAULT NULL COMMENT '删除标记',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='节点表';

-- ----------------------------
-- Table structure for t_act_process
-- ----------------------------
DROP TABLE IF EXISTS `t_act_process`;
CREATE TABLE `t_act_process` (
  `id` varchar(255) NOT NULL COMMENT '主键id',
  `category_id` varchar(255) DEFAULT NULL COMMENT '所属分类',
  `deployment_id` varchar(255) DEFAULT NULL COMMENT '部署id',
  `description` varchar(255) DEFAULT NULL COMMENT '描述/备注',
  `diagram_name` varchar(255) DEFAULT NULL COMMENT '流程图片名',
  `latest` bit(1) DEFAULT NULL COMMENT '最新版本',
  `name` varchar(255) DEFAULT NULL COMMENT '流程名称',
  `process_key` varchar(255) DEFAULT NULL COMMENT '流程标识名称',
  `status` int(11) DEFAULT NULL COMMENT '流程状态 部署后默认1激活',
  `version` int(11) DEFAULT NULL COMMENT '版本',
  `xml_name` varchar(255) DEFAULT NULL COMMENT 'xml文件名',
  `business_table` varchar(255) DEFAULT NULL COMMENT '关联业务表名',
  `route_name` varchar(255) DEFAULT NULL COMMENT '关联前端表单路由名',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_flag` int(11) DEFAULT NULL COMMENT '删除标记',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='流程定义表';

-- ----------------------------
-- Table structure for t_city
-- ----------------------------
DROP TABLE IF EXISTS `t_city`;
CREATE TABLE `t_city` (
  `id` varchar(32) NOT NULL COMMENT '主键id',
  `label` varchar(30) NOT NULL COMMENT '城市',
  `province_id` varchar(32) NOT NULL COMMENT '省份id',
  `area_code` varchar(4) DEFAULT NULL COMMENT '长途区号',
  `post_code` varchar(6) DEFAULT NULL COMMENT '邮政编码',
  `sort_order` decimal(10,2) DEFAULT NULL COMMENT '排序',
  `del_flag` int(11) NOT NULL DEFAULT '0' COMMENT '删除标志',
  `create_by` varchar(32) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `province_id` (`province_id`) USING BTREE,
  KEY `del_flag` (`del_flag`),
  KEY `sort_order` (`sort_order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='城市';

-- ----------------------------
-- Records of t_city
-- ----------------------------
BEGIN;
INSERT INTO `t_city` VALUES ('1', '北京市', '1', '010', '100000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('10', '秦皇岛市', '5', '0335', '066000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('100', '丽水市', '12', '0578', '323000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('101', '合肥市', '13', '0551', '230000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('102', '宿州市', '13', '0557', '234000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('103', '淮北市', '13', '0561', '235000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('104', '亳州市', '13', '0558', '236800', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('105', '阜阳市', '13', '0558', '236000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('106', '蚌埠市', '13', '0552', '233000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('107', '淮南市', '13', '0554', '232000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('108', '滁州市', '13', '0550', '239000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('109', '马鞍山市', '13', '0555', '243000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('11', '唐山市', '5', '0315', '063000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('110', '芜湖市', '13', '0553', '241000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('111', '铜陵市', '13', '0562', '244000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('112', '安庆市', '13', '0556', '246000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('113', '黄山市', '13', '0559', '245000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('114', '六安市', '13', '0564', '237000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('115', '巢湖市', '13', '0565', '238000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('116', '池州市', '13', '0566', '247100', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('117', '宣城市', '13', '0563', '242000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('118', '福州市', '14', '0591', '350000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('119', '南平市', '14', '0599', '353000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('12', '廊坊市', '5', '0316', '065000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('120', '莆田市', '14', '0594', '351100', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('121', '三明市', '14', '0598', '365000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('122', '泉州市', '14', '0595', '362000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('123', '厦门市', '14', '0592', '361000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('124', '漳州市', '14', '0596', '363000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('125', '龙岩市', '14', '0597', '364000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('126', '宁德市', '14', '0593', '352100', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('127', '南昌市', '15', '0791', '330000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('128', '九江市', '15', '0792', '332000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('129', '景德镇市', '15', '0798', '333000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('13', '保定市', '5', '0312', '071000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('130', '鹰潭市', '15', '0701', '335000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('131', '新余市', '15', '0790', '332000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('132', '萍乡市', '15', '0799', '337000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('133', '赣州市', '15', '0797', '341000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('134', '上饶市', '15', '0793', '334000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('135', '抚州市', '15', '0794', '344000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('136', '宜春市', '15', '0795', '336000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('137', '吉安市', '15', '0796', '343000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('138', '济南市', '16', '0531', '250000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('139', '青岛市', '16', '0532', '266000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('14', '衡水市', '5', '0318', '053000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('140', '聊城市', '16', '0635', '252000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('141', '德州市', '16', '0534', '253000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('142', '东营市', '16', '0546', '257000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('143', '淄博市', '16', '0533', '255000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('144', '潍坊市', '16', '0536', '261000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('145', '烟台市', '16', '0535', '264000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('146', '威海市', '16', '0631', '264200', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('147', '日照市', '16', '0633', '276800', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('148', '临沂市', '16', '0539', '276000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('149', '枣庄市', '16', '0632', '277100', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('15', '沧州市', '5', '0317', '054000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('150', '济宁市', '16', '0537', '272100', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('151', '泰安市', '16', '0538', '271000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('152', '莱芜市', '16', '0634', '271100', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('153', '滨州市', '16', '0543', '256600', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('154', '菏泽市', '16', '0530', '274000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('155', '郑州市', '17', '0371', '450000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('156', '开封市', '17', '0378', '475000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('157', '三门峡市', '17', '0398', '472000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('158', '洛阳市', '17', '0379', '471000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('159', '焦作市', '17', '0391', '454000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('16', '邢台市', '5', '0319', '054000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('160', '新乡市', '17', '0373', '453000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('161', '鹤壁市', '17', '0373', '453000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('162', '安阳市', '17', '0372', '455000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('163', '濮阳市', '17', '0393', '457000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('164', '商丘市', '17', '0370', '476000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('165', '许昌市', '17', '0374', '461000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('166', '漯河市', '17', '0395', '462000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('167', '平顶山市', '17', '0375', '467000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('168', '南阳市', '17', '0377', '473000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('169', '信阳市', '17', '0376', '464000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('17', '邯郸市', '5', '0310', '056000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('170', '周口市', '17', '0394', '4666', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('171', '驻马店市', '17', '0396', '463000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('172', '济源市', '17', '0391', '459000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('173', '武汉市', '18', '027', '430000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('174', '十堰市', '18', '0719', '442000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('175', '襄樊市', '18', '0710', '441000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('176', '荆门市', '18', '0724', '448000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('177', '孝感市', '18', '0712', '432000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('178', '黄冈市', '18', '0713', '438000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('179', '鄂州市', '18', '0711', '436000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('18', '太原市', '6', '0351', '030000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('180', '黄石市', '18', '0714', '435000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('181', '咸宁市', '18', '0715', '437000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('182', '荆州市', '18', '0716', '434000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('183', '宜昌市', '18', '0717', '443000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('184', '随州市', '18', '0722', '441300', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('185', '省直辖县级行政单位', '18', '0728', '430000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('186', '恩施州', '18', '0718', '445000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('187', '长沙市', '19', '0731', '410000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('188', '张家界市', '19', '0744', '427000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('189', '常德市', '19', '0736', '415000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('19', '朔州市', '6', '0349', '036000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('190', '益阳市', '19', '0737', '413000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('191', '岳阳市', '19', '0730', '414000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('192', '株洲市', '19', '0733', '412000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('193', '湘潭市', '19', '0732', '411100', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('194', '衡阳市', '19', '0734', '421000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('195', '郴州市', '19', '0735', '423000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('196', '永州市', '19', '0746', '425000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('197', '邵阳市', '19', '0739', '422000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('198', '怀化市', '19', '0745', '418000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('199', '娄底市', '19', '0738', '417000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('2', '天津市', '2', '022', '300000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('20', '大同市', '6', '0352', '037000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('200', '湘西州', '19', '0743', '416000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('201', '广州市', '20', '020', '510000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('202', '深圳市', '20', '0755', '518000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('203', '清远市', '20', '0763', '511500', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('204', '韶关市', '20', '0751', '512000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('205', '河源市', '20', '0762', '517000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('206', '梅州市', '20', '0753', '514000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('207', '潮州市', '20', '0768', '521000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('208', '汕头市', '20', '0754', '515000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('209', '揭阳市', '20', '0663', '522000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('21', '阳泉市', '6', '0353', '045000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('210', '汕尾市', '20', '0660', '516600', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('211', '惠州市', '20', '0752', '516000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('212', '东莞市', '20', '0769', '523000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('213', '珠海市', '20', '0756', '519000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('214', '中山市', '20', '0760', '528400', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('215', '江门市', '20', '0750', '529000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('216', '佛山市', '20', '0757', '528000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('217', '肇庆市', '20', '0758', '526000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('218', '云浮市', '20', '0766', '527300', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('219', '阳江市', '20', '0662', '529500', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('22', '长治市', '6', '0355', '046000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('220', '茂名市', '20', '0668', '525000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('221', '湛江市', '20', '0759', '524000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('222', '南宁市', '21', '0771', '530000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('223', '桂林市', '21', '0773', '541000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('224', '柳州市', '21', '0772', '545000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('225', '梧州市', '21', '0774', '543000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('226', '贵港市', '21', '0775', '537100', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('227', '玉林市', '21', '0775', '537000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('228', '钦州市', '21', '0777', '535000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('229', '北海市', '21', '0779', '536000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('23', '晋城市', '6', '0356', '048000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('230', '防城港市', '21', '0770', '538000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('231', '崇左市', '21', '0771', '532200', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('232', '百色市', '21', '0776', '533000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('233', '河池市', '21', '0778', '547000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('234', '来宾市', '21', '0772', '546100', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('235', '贺州市', '21', '0774', '542899', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('236', '海口市', '22', '0898', '570000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('237', '三亚市', '22', '0899', '572000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('238', '省直辖行政单位', '22', '0898', '570000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('239', '成都市', '23', '028', '610000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('24', '忻州市', '6', '0350', '034000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('240', '广元市', '23', '0839', '628017', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('241', '绵阳市', '23', '0816', '621000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('242', '德阳市', '23', '0838', '618000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('243', '南充市', '23', '0817', '637000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('244', '广安市', '23', '0826', '638000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('245', '遂宁市', '23', '0825', '629000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('246', '内江市', '23', '0832', '641000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('247', '乐山市', '23', '0833', '614000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('248', '自贡市', '23', '0813', '643000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('249', '泸州市', '23', '0830', '646000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('25', '晋中市', '6', '0354', '030000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('250', '宜宾市', '23', '0831', '644000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('251', '攀枝花市', '23', '0812', '617000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('252', '巴中市', '23', '0827', '636000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('253', '达州市', '23', '0818', '635000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('254', '资阳市', '23', '028', '641300', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('255', '眉山市', '23', '028', '620010', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('256', '雅安市', '23', '0835', '625000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('257', '阿坝州', '23', '0837', '624000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('258', '甘孜州', '23', '0836', '626000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('259', '凉山州', '23', '0834', '615000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('26', '临汾市', '6', '0357', '041000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('260', '贵阳市', '24', '0851', '550000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('261', '六盘水市', '24', '0858', '553000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('262', '遵义市', '24', '0852', '563000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('263', '安顺市', '24', '0853', '561000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('264', '毕节地区', '24', '0857', '551700', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('265', '铜仁地区', '24', '0856', '554300', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('266', '黔东南州', '24', '0855', '556000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('267', '黔南州', '24', '0854', '558000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('268', '黔西南州', '24', '0859', '562400', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('269', '昆明市', '25', '0871', '650000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('27', '吕梁市', '6', '0358', '033000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('270', '曲靖市', '25', '0874', '655000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('271', '玉溪市', '25', '0877', '653100', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('272', '保山市', '25', '0875', '678000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('273', '昭通市', '25', '0870', '657000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('274', '丽江市', '25', '0888', '674100', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('275', '思茅市', '25', '0879', '665000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('276', '临沧市', '25', '0883', '677000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('277', '德宏州', '25', '0692', '678400', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('278', '怒江州', '25', '0886', '673200', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('279', '迪庆州', '25', '0887', '674400', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('28', '运城市', '6', '0359', '044000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('280', '大理州', '25', '0872', '671000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('281', '楚雄州', '25', '0878', '675000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('282', '红河州', '25', '0873', '661100', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('283', '文山州', '25', '0876', '663000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('284', '西双版纳州', '25', '0691', '666100', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('285', '拉萨市', '26', '0891', '850000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('286', '那曲地区', '26', '0896', '852000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('287', '昌都地区', '26', '0895', '854000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('288', '林芝地区', '26', '0894', '860000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('289', '山南地区', '26', '0893', '856000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('29', '呼和浩特市', '7', '0471', '010000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('290', '日喀则地区', '26', '0892', '857000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('291', '阿里地区', '26', '0897', '859000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('292', '西安市', '27', '029', '710000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('293', '延安市', '27', '0911', '716000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('294', '铜川市', '27', '0919', '727000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('295', '渭南市', '27', '0913', '714000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('296', '咸阳市', '27', '0910', '712000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('297', '宝鸡市', '27', '0917', '721000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('298', '汉中市', '27', '0916', '723000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('299', '榆林市', '27', '0912', '719000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('3', '上海市', '3', '021', '200000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('30', '包头市', '7', '0472', '014000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('300', '安康市', '27', '0915', '725000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('301', '商洛市', '27', '0914', '726000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('302', '兰州市', '28', '0931', '730000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('303', '嘉峪关市', '28', '0937', '735100', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('304', '白银市', '28', '0943', '730900', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('305', '天水市', '28', '0938', '741000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('306', '武威市', '28', '0935', '733000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('307', '酒泉市', '28', '0937', '735000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('308', '张掖市', '28', '0936', '734000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('309', '庆阳市', '28', '0934', '745000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('31', '乌海市', '7', '0473', '016000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('310', '平凉市', '28', '0933', '744000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('311', '定西市', '28', '0932', '743000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('312', '陇南市', '28', '0939', '742500', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('313', '临夏州', '28', '0930', '731100', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('314', '甘南州', '28', '0941', '747000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('315', '西宁市', '29', '0971', '810000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('316', '海东地区', '29', '0972', '814000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('317', '海北州', '29', '0970', '812200', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('318', '海南州', '29', '0974', '813000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('319', '黄南州', '29', '0973', '811300', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('32', '赤峰市', '7', '0476', '024000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('320', '果洛州', '29', '0975', '814000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('321', '玉树州', '29', '0976', '815000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('322', '海西州', '29', '0979', '817000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('323', '银川市', '30', '0951', '750000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('324', '石嘴山市', '30', '0952', '753000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('325', '吴忠市', '30', '0953', '751100', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('326', '固原市', '30', '0954', '756000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('327', '中卫市', '30', '0955', '755000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('328', '乌鲁木齐市', '31', '0991', '830000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('329', '克拉玛依市', '31', '0990', '834000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('33', '通辽市', '7', '0475', '028000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('330', '自治区直辖县级行政单位', '31', '0991', '830000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('331', '喀什地区', '31', '0998', '844000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('332', '阿克苏地区', '31', '0997', '843000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('333', '和田地区', '31', '0903', '848000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('334', '吐鲁番地区', '31', '0995', '838000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('335', '哈密地区', '31', '0902', '839000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('336', '克孜勒苏柯州', '31', '0908', '845350', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('337', '博尔塔拉州', '31', '0909', '833400', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('338', '昌吉州', '31', '0994', '831100', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('339', '巴音郭楞州', '31', '0996', '841000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('34', '呼伦贝尔市', '7', '0470', '021000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('340', '伊犁州', '31', '0999', '835000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('341', '塔城地区', '31', '0901', '834700', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('342', '阿勒泰地区', '31', '0906', '836500', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('35', '鄂尔多斯市', '7', '0477', '017000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('36', '乌兰察布市', '7', '0474', '012000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('37', '巴彦淖尔市', '7', '0478', '015000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('38', '兴安盟', '7', '0482', '137400', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('39', '锡林郭勒盟', '7', '0479', '026000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('4', '重庆市', '4', '023', '400000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('40', '阿拉善盟', '7', '0483', '750306', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('41', '沈阳市', '8', '024', '110000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('42', '朝阳市', '8', '0421', '122000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('43', '阜新市', '8', '0418', '123000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('44', '铁岭市', '8', '0410', '112000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('45', '抚顺市', '8', '0413', '113000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('46', '本溪市', '8', '0414', '117000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('47', '辽阳市', '8', '0419', '111000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('48', '鞍山市', '8', '0412', '114000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('49', '丹东市', '8', '0415', '118000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('50', '大连市', '8', '0411', '116000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('51', '营口市', '8', '0417', '115000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('52', '盘锦市', '8', '0427', '124000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('53', '锦州市', '8', '0416', '121000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('54', '葫芦岛市', '8', '0429', '125000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('55', '长春市', '9', '0431', '130000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('56', '白城市', '9', '0436', '137000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('57', '松原市', '9', '0438', '138000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('58', '吉林市', '9', '0433', '132000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('59', '四平市', '9', '0434', '136000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('60', '辽源市', '9', '0437', '136200', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('61', '通化市', '9', '0435', '134000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('62', '白山市', '9', '0439', '134300', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('63', '延边州', '9', '0433', '133000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('64', '哈尔滨市', '10', '0451', '150000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('65', '齐齐哈尔市', '10', '0452', '161000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('66', '七台河市', '10', '0464', '154600', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('67', '黑河市', '10', '0456', '164300', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('68', '大庆市', '10', '0459', '163000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('69', '鹤岗市', '10', '0454', '154100', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('7', '石家庄市', '5', '0311', '050000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('70', '伊春市', '10', '0458', '153000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('71', '佳木斯市', '10', '0454', '154000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('72', '双鸭山市', '10', '0454', '151000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('73', '鸡西市', '10', '0453', '158100', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('74', '牡丹江市', '10', '0453', '157000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('75', '绥化市', '10', '0458', '152000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('76', '大兴安岭地区', '10', '0457', '165000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('77', '南京市', '11', '025', '210000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('78', '徐州市', '11', '0516', '221000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('79', '连云港市', '11', '0518', '222000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('8', '张家口市', '5', '0310', '056000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('80', '宿迁市', '11', '0527', '223800', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('81', '淮安市', '11', '0517', '223000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('82', '盐城市', '11', '0515', '224000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('83', '扬州市', '11', '0514', '225000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('84', '泰州市', '11', '0523', '225300', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('85', '南通市', '11', '0513', '226000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('86', '镇江市', '11', '0511', '212000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('87', '常州市', '11', '0519', '213000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('88', '无锡市', '11', '0510', '214000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('89', '苏州市', '11', '0512', '215000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('9', '承德市', '5', '0314', '067000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('90', '杭州市', '12', '0571', '310000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('91', '湖州市', '12', '0572', '313000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('92', '嘉兴市', '12', '0573', '314000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('93', '舟山市', '12', '0580', '316000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('94', '宁波市', '12', '0574', '315000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('95', '绍兴市', '12', '0575', '312000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('96', '衢州市', '12', '0570', '324000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('97', '金华市', '12', '0579', '321000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('98', '台州市', '12', '0576', '318000', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_city` VALUES ('99', '温州市', '12', '0577', '325000', NULL, 0, NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_country
-- ----------------------------
DROP TABLE IF EXISTS `t_country`;
CREATE TABLE `t_country` (
  `id` varchar(32) NOT NULL COMMENT '主键id',
  `label` varchar(50) NOT NULL COMMENT '中文名',
  `label_en` varchar(50) DEFAULT NULL COMMENT '英文名',
  `code` varchar(50) DEFAULT NULL COMMENT '国家码',
  `sort_order` decimal(10,2) DEFAULT '0.00' COMMENT '排序',
  `del_flag` int(11) NOT NULL DEFAULT '0' COMMENT '删除标志',
  `create_by` varchar(32) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `sort` (`sort_order`) USING BTREE,
  KEY `del_flag` (`del_flag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='国家';

-- ----------------------------
-- Records of t_country
-- ----------------------------
BEGIN;
INSERT INTO `t_country` VALUES ('1', '阿尔巴尼亚', 'Albania', '355', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('10', '伯利兹', 'Belize', '501', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('100', '俄罗斯', 'Russia', '7', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('101', '委内瑞拉', 'Venezuela', '58', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('102', '也门(北)', 'The Yemen Rep.(N)', '967', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('103', '也门(难)', 'The Yemen Rep.(S)', '969', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('104', '南斯拉夫', 'Yugoslavia', '38', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('105', '扎伊尔', 'Zaire', '243', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('106', '赞比亚', 'Zambia', '260', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('107', '津巴布韦', 'Zimbabew', '263', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('108', '德国', 'Germany', '49', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('109', '捷克', 'Czech', '00420', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('11', '玻利维亚', 'Bolivia', '591', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('12', '巴西', 'Brazil', '55', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('13', '保加利亚', 'Bulgaria', '359', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('14', '喀麦隆', 'Cameroon', '237', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('15', '加拿大', 'Canada', '1', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('16', '智利', 'Chile', '56', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('17', '中国', 'China', '86', 9999.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('18', '哥伦比亚', 'Colombia', '57', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('19', '刚果', 'Congo', '242', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('2', '阿尔及利亚', 'Algeria', '213', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('20', '哥斯达黎加', 'Costa Rica', '506', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('21', '古巴', 'Cuba', '53', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('22', '丹麦', 'Denmark', '45', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('23', '塞浦路斯', 'Cyprus', '357', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('24', '厄多瓜尔', 'Ecuador', '593', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('25', '埃及', 'Egypt', '20', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('26', '芬兰', 'Finland', '358', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('27', '法国', 'France', '33', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('28', '直布罗陀', 'Gibraltar', '350', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('29', '希腊', 'Greece', '30', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('3', '安道尔', 'Andorra', '376', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('30', '几内亚', 'Guinea', '224', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('31', '圭亚那', 'Guiana', '592', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('32', '海地', 'Haiti', '509', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('33', '洪都拉斯', 'Honduras', '504', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('35', '匈牙利', 'Hungary', '36', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('36', '冰岛', 'Iceland', '354', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('37', '印度', 'India', '91', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('38', '印度尼西亚', 'Indonesia', '62', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('39', '伊朗', 'Iran', '98', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('4', '安哥拉', 'Angola', '244', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('40', '伊拉克', 'Iraq', '964', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('41', '爱尔兰', 'Ireland', '353', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('42', '以色列', 'Israel', '972', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('43', '意大利', 'Italy', '39', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('44', '牙买加', 'Jamaica', '1876', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('45', '日本', 'Japan', '81', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('46', '约旦', 'Jordan', '962', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('47', '肯尼亚', 'Kenya', '254', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('48', '朝鲜', 'North Korea', '850', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('49', '科威特', 'Kuwait', '965', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('5', '阿根廷', 'Aregntina', '54', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('50', '老挝', 'Laos', '856', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('51', '黎巴嫩', 'Leanon', '961', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('52', '利比里亚', 'Liberia', '231', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('53', '利比亚', 'Libya', '218', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('54', '卢森堡', 'Luxembourg', '352', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('55', '列支敦士登', 'Liechtenstein', '4175', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('56', '马达加斯加', 'Madagascar', '261', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('58', '马来西亚', 'Malaysia', '60', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('59', '马尔代夫', 'Maldive', '960', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('6', '澳大利亚', 'Australia', '61', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('60', '毛里求斯', 'Mauritius', '230', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('61', '墨西哥', 'Mexico', '52', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('62', '摩纳哥', 'Monaco', '3393', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('63', '摩洛哥', 'Morocco', '212', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('64', '缅甸', 'Myandmar', '95', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('65', '尼泊尔', 'Nepal', '977', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('66', '荷兰', 'Netherlands', '31', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('67', '新西兰', 'New Zealamd', '64', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('68', '尼日尔', 'Niger', '227', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('69', '尼日利亚', 'Nigeria', '234', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('7', '奥地利', 'Austria', '43', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('70', '挪威', 'Norway', '47', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('71', '巴基斯坦', 'Paskstan', '92', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('72', '巴拿马', 'Panama', '507', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('73', '巴拉圭', 'Paraguay', '595', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('74', '秘鲁', 'Peru', '51', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('75', '菲律宾', 'Philippines', '63', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('76', '波兰', 'Poland', '48', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('77', '葡萄牙', 'Portugal', '351', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('78', '卡塔尔', 'Qatar', '974', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('79', '罗马尼亚', 'Remania', '40', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('8', '孟加拉国', 'Bangladesh', '880', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('80', '沙特阿拉伯', 'Saudi', '966', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('81', '新加坡', 'Singapore', '65', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('82', '索马里', 'Somali', '252', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('83', '西班牙', 'Spain', '34', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('84', '韩国', 'South Korea', '82', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('85', '斯里兰卡', 'Sir Lanka', '94', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('86', '苏丹', 'Sudan', '249', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('87', '瑞典', 'Swede', '46', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('88', '瑞士', 'Switzerland', '41', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('89', '叙利亚', 'Syia', '63', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('9', '比利时', 'Belgium', '32', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('90', '坦桑尼亚', 'Tanzania', '255', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('92', '泰国', 'Thailand', '66', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('93', '多哥', 'Togo', '228', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('94', '汤加', 'Tonga', '676', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('95', '突尼斯', 'Tunisia', '216', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('96', '土耳其', 'Turkey', '90', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('97', '英国', 'U.K.', '44', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('98', '乌拉圭', 'Uruguay', '589', 0.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_country` VALUES ('99', '美国', 'U.S.A', '1', 0.00, 0, NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_department
-- ----------------------------
DROP TABLE IF EXISTS `t_department`;
CREATE TABLE `t_department` (
  `id` varchar(255) NOT NULL COMMENT '主键id',
  `parent_id` varchar(255) DEFAULT NULL COMMENT '父id',
  `sort_order` decimal(10,2) DEFAULT NULL COMMENT '排序值',
  `status` int(11) DEFAULT NULL COMMENT '是否启用 0启用 -1禁用',
  `title` varchar(255) DEFAULT NULL COMMENT '部门名称',
  `is_parent` bit(1) DEFAULT NULL COMMENT '是否为父节点(含子节点) 默认false',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_flag` int(11) DEFAULT NULL COMMENT '删除标记',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='部门表';

-- ----------------------------
-- Records of t_department
-- ----------------------------
BEGIN;
INSERT INTO `t_department` VALUES ('40322777781112832', '0', 1.00, 0, '部门1', b'1', '', '2018-08-10 20:40:40', '682265633886208', '2019-07-19 11:15:24', 0);
INSERT INTO `t_department` VALUES ('40343262766043136', '0', 2.00, 0, '部门2', b'1', '', '2018-08-10 22:02:04', '682265633886208', '2019-07-19 11:15:32', 0);
COMMIT;

-- ----------------------------
-- Table structure for t_department_header
-- ----------------------------
DROP TABLE IF EXISTS `t_department_header`;
CREATE TABLE `t_department_header` (
  `id` varchar(255) NOT NULL COMMENT '主键id',
  `department_id` varchar(255) DEFAULT NULL COMMENT '关联部门id',
  `type` int(11) DEFAULT NULL COMMENT '负责人类型 默认0主要 1副职',
  `user_id` varchar(255) DEFAULT NULL COMMENT '关联部门负责人',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_flag` int(11) DEFAULT NULL COMMENT '删除标记',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='部门负责人表';

-- ----------------------------
-- Table structure for t_dict
-- ----------------------------
DROP TABLE IF EXISTS `t_dict`;
CREATE TABLE `t_dict` (
  `id` varchar(255) NOT NULL COMMENT '主键id',
  `description` varchar(255) DEFAULT NULL COMMENT '备注',
  `title` varchar(255) DEFAULT NULL COMMENT '字典名称',
  `type` varchar(255) DEFAULT NULL COMMENT '字典类型',
  `sort_order` decimal(10,2) DEFAULT NULL COMMENT '排序值',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_flag` int(11) DEFAULT NULL COMMENT '删除标记',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='字典表';

-- ----------------------------
-- Records of t_dict
-- ----------------------------
BEGIN;
INSERT INTO `t_dict` VALUES ('131584167279333376', '', '所属行业', 'industry', 0.00, 'admin', '2019-04-19 16:40:51', 'admin', '2019-04-19 16:40:51', 0);
INSERT INTO `t_dict` VALUES ('131584329418543104', '', '展会规模', 'scale', 0.00, 'admin', '2019-04-19 16:41:30', '682265633886208', '2019-05-28 17:18:10', 0);
INSERT INTO `t_dict` VALUES ('131584959155539968', '', '企业性质', 'nature', 0.00, 'admin', '2019-04-19 16:44:00', 'admin', '2019-04-19 16:44:00', 0);
INSERT INTO `t_dict` VALUES ('131585111937257472', '', '重要级别', 'levels', 0.00, 'admin', '2019-04-19 16:44:36', 'admin', '2019-04-19 16:44:36', 0);
INSERT INTO `t_dict` VALUES ('132634126397214720', '', '联系人类别', 'contactType', 0.00, '682265633886208', '2019-04-22 14:13:01', '682265633886208', '2019-04-22 14:13:01', 0);
INSERT INTO `t_dict` VALUES ('132932722535436288', '', '跟进标签', 'followLabel', 0.00, '682265633886208', '2019-04-23 09:59:32', '682265633886208', '2019-04-29 09:03:03', 0);
INSERT INTO `t_dict` VALUES ('135093709900353536', '', '拜访结果', 'visitResult', 0.00, '682265633886208', '2019-04-29 09:06:31', '682265633886208', '2019-04-29 09:06:31', 0);
INSERT INTO `t_dict` VALUES ('135094593044615168', '', '暂无机会原因', 'noChanceReason', 0.00, '682265633886208', '2019-04-29 09:10:02', '682265633886208', '2019-04-29 09:10:02', 0);
INSERT INTO `t_dict` VALUES ('145728432855060480', '', '展会届数', 'period', 0.00, '682265633886208', '2019-05-28 17:25:07', '682265633886208', '2019-05-28 17:25:07', 0);
INSERT INTO `t_dict` VALUES ('145729174860992512', '', '联络情况', 'contactSituation', 0.00, '682265633886208', '2019-05-28 17:28:04', '682265633886208', '2019-05-28 17:28:04', 0);
INSERT INTO `t_dict` VALUES ('75135930788220928', '', '性别', 'sex', 0.00, 'admin', '2018-11-14 22:15:43', 'admin', '2018-11-27 01:39:06', 0);
INSERT INTO `t_dict` VALUES ('75383353938808832', '', '消息类型', 'message_type', 1.00, 'admin', '2018-11-15 14:38:53', 'admin', '2018-11-27 01:39:15', 0);
INSERT INTO `t_dict` VALUES ('75388696739713024', '', '按钮权限类型', 'permission_type', 2.00, 'admin', '2018-11-15 15:00:07', 'admin', '2018-11-27 01:39:22', 0);
INSERT INTO `t_dict` VALUES ('75392985935646720', '', '腾讯云对象存储区域', 'tencent_bucket_region', 3.00, 'admin', '2018-11-15 15:17:10', 'admin', '2018-11-27 01:39:29', 0);
INSERT INTO `t_dict` VALUES ('79717732567748608', '', '流程节点类型', 'process_node_type', 4.00, 'admin', '2018-11-27 13:42:10', 'admin', '2018-11-27 13:42:10', 0);
INSERT INTO `t_dict` VALUES ('81843858882695168', '', '优先级', 'priority', 5.00, 'admin', '2018-12-03 10:30:38', 'admin', '2018-12-03 10:30:49', 0);
INSERT INTO `t_dict` VALUES ('82236987314016256', '', '业务表', 'business_table', 6.00, 'admin', '2018-12-04 12:32:47', 'admin', '2018-12-04 12:32:47', 0);
INSERT INTO `t_dict` VALUES ('82236987314016257', '', '业务表单路由', 'business_form', 7.00, 'admin', '2018-12-04 12:32:47', 'admin', '2018-12-04 12:32:47', 0);
INSERT INTO `t_dict` VALUES ('99020862912466944', '', '请假类型', 'leave_type', 8.00, 'admin', '2019-01-19 20:05:54', 'admin', '2019-01-19 20:06:10', 0);
COMMIT;

-- ----------------------------
-- Table structure for t_dict_data
-- ----------------------------
DROP TABLE IF EXISTS `t_dict_data`;
CREATE TABLE `t_dict_data` (
  `id` varchar(255) NOT NULL COMMENT '主键ID',
  `description` varchar(255) DEFAULT NULL COMMENT '备注',
  `dict_id` varchar(255) DEFAULT NULL COMMENT '所属字典',
  `sort_order` decimal(10,2) DEFAULT NULL COMMENT '排序值',
  `status` int(11) DEFAULT NULL COMMENT '是否启用 0启用 -1禁用',
  `title` varchar(255) DEFAULT NULL COMMENT '数据名称',
  `value` varchar(255) DEFAULT NULL COMMENT '数据值',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_flag` int(11) DEFAULT NULL COMMENT '删除标记',
  PRIMARY KEY (`id`),
  KEY `dict_id` (`dict_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='字典数据表';

-- ----------------------------
-- Records of t_dict_data
-- ----------------------------
BEGIN;
INSERT INTO `t_dict_data` VALUES ('125170157323554816', '', '75383353938808832', 3.00, 0, '工作流', '工作流', 'admin', '2019-04-01 23:53:52', 'admin', '2019-04-01 23:53:52', 0);
INSERT INTO `t_dict_data` VALUES ('131584229745102848', '', '131584167279333376', 0.00, 0, '烘焙', '烘焙', 'admin', '2019-04-19 16:41:06', '682265633886208', '2019-05-28 17:20:43', 0);
INSERT INTO `t_dict_data` VALUES ('131584271612645376', '', '131584167279333376', 0.00, 0, '饮料', '饮料', 'admin', '2019-04-19 16:41:16', '682265633886208', '2019-05-28 17:20:40', 0);
INSERT INTO `t_dict_data` VALUES ('131584454392025088', '', '131584329418543104', 1.00, 0, '5-10万平', '5-10万平', 'admin', '2019-04-19 16:42:00', '682265633886208', '2019-05-28 17:20:01', 0);
INSERT INTO `t_dict_data` VALUES ('131584549351067648', '', '131584329418543104', 0.00, 0, '5万平以下', '5万平以下', 'admin', '2019-04-19 16:42:22', '682265633886208', '2019-05-28 17:19:57', 0);
INSERT INTO `t_dict_data` VALUES ('131585011286544384', '', '131584959155539968', 0.00, 0, '国有', '1', 'admin', '2019-04-19 16:44:12', '682265633886208', '2019-04-25 14:06:25', 1);
INSERT INTO `t_dict_data` VALUES ('131585040185298944', '', '131584959155539968', 0.00, 0, '合作', '2', 'admin', '2019-04-19 16:44:19', '682265633886208', '2019-04-25 14:06:33', 1);
INSERT INTO `t_dict_data` VALUES ('131585174902149120', '', '131585111937257472', 0.00, 0, '青铜', '1', 'admin', '2019-04-19 16:44:51', 'admin', '2019-04-19 16:44:51', 0);
INSERT INTO `t_dict_data` VALUES ('131585202832019456', '', '131585111937257472', 0.00, 0, '白银', '2', 'admin', '2019-04-19 16:44:58', 'admin', '2019-04-19 16:44:58', 0);
INSERT INTO `t_dict_data` VALUES ('131585241780326400', '', '131585111937257472', 0.00, 0, '黄金', '3', 'admin', '2019-04-19 16:45:07', 'admin', '2019-04-19 16:45:07', 0);
INSERT INTO `t_dict_data` VALUES ('131585281877872640', '', '131585111937257472', 0.00, 0, '铂金', '4', 'admin', '2019-04-19 16:45:17', 'admin', '2019-04-19 16:45:17', 0);
INSERT INTO `t_dict_data` VALUES ('131585316376023040', '', '131585111937257472', 0.00, 0, '钻石', '5', 'admin', '2019-04-19 16:45:25', 'admin', '2019-04-19 16:45:25', 0);
INSERT INTO `t_dict_data` VALUES ('131585351318769664', '', '131585111937257472', 0.00, 0, '星耀', '6', 'admin', '2019-04-19 16:45:34', 'admin', '2019-04-19 16:45:34', 0);
INSERT INTO `t_dict_data` VALUES ('131585397930070016', '', '131585111937257472', 0.00, 0, '王者', '7', 'admin', '2019-04-19 16:45:45', '682265633886208', '2019-04-19 20:25:15', 0);
INSERT INTO `t_dict_data` VALUES ('131630571259432960', '', '131584959155539968', 4.00, 0, '其他', '其他', '682265633886208', '2019-04-19 19:45:15', '682265633886208', '2019-05-28 17:22:08', 0);
INSERT INTO `t_dict_data` VALUES ('132634190804946944', '', '132634126397214720', 0.00, 0, '联系人', '1', '682265633886208', '2019-04-22 14:13:16', '682265633886208', '2019-04-22 14:13:16', 0);
INSERT INTO `t_dict_data` VALUES ('132634274363871232', '', '132634126397214720', 0.00, 0, '决策人', '2', '682265633886208', '2019-04-22 14:13:36', '682265633886208', '2019-04-22 14:13:36', 0);
INSERT INTO `t_dict_data` VALUES ('132932764658831360', '', '132932722535436288', 0.00, 0, '有拜访机会', '有拜访机会', '682265633886208', '2019-04-23 09:59:42', '682265633886208', '2019-04-29 09:07:34', 0);
INSERT INTO `t_dict_data` VALUES ('132932815221166080', '', '132932722535436288', 1.00, 0, '成功预约', '成功预约', '682265633886208', '2019-04-23 09:59:54', '682265633886208', '2019-04-29 09:07:39', 0);
INSERT INTO `t_dict_data` VALUES ('132932855205466112', '', '132932722535436288', 2.00, 0, '已拜访', '已拜访', '682265633886208', '2019-04-23 10:00:03', '682265633886208', '2019-04-29 09:07:43', 0);
INSERT INTO `t_dict_data` VALUES ('133719023195000832', '', '131584167279333376', 0.00, 0, '电子商务', '电子商务', '682265633886208', '2019-04-25 14:04:01', '682265633886208', '2019-05-28 17:20:36', 0);
INSERT INTO `t_dict_data` VALUES ('133719741456977920', '', '131584959155539968', 3.00, 0, '民办展览公司', '民办展览公司', '682265633886208', '2019-04-25 14:06:52', '682265633886208', '2019-05-28 17:21:52', 0);
INSERT INTO `t_dict_data` VALUES ('133719781181231104', '', '131584959155539968', 2.00, 0, '外资展览集团', '外资展览集团', '682265633886208', '2019-04-25 14:07:01', '682265633886208', '2019-05-28 17:21:41', 0);
INSERT INTO `t_dict_data` VALUES ('133719815977177088', '', '131584959155539968', 1.00, 0, '国资展览集团', '国资展览集团', '682265633886208', '2019-04-25 14:07:10', '682265633886208', '2019-05-28 17:21:28', 0);
INSERT INTO `t_dict_data` VALUES ('133719863951626240', '', '131584959155539968', 0.00, 0, '个体工商户', '7', '682265633886208', '2019-04-25 14:07:21', '682265633886208', '2019-04-25 14:07:21', 1);
INSERT INTO `t_dict_data` VALUES ('133719902140764160', '', '131584959155539968', 0.00, 0, '报关', '8', '682265633886208', '2019-04-25 14:07:30', '682265633886208', '2019-04-25 14:07:30', 1);
INSERT INTO `t_dict_data` VALUES ('133719928078340096', '', '131584959155539968', 0.00, 0, '协会/贸促会/商会', '协会/贸促会/商会', '682265633886208', '2019-04-25 14:07:36', '682265633886208', '2019-05-28 17:21:20', 0);
INSERT INTO `t_dict_data` VALUES ('133725409538740224', '', '132634126397214720', 0.00, 0, '执行人', '3', '682265633886208', '2019-04-25 14:29:23', '682265633886208', '2019-04-25 14:29:23', 0);
INSERT INTO `t_dict_data` VALUES ('135093490055909376', '', '132932722535436288', 4.00, 0, '其他（无意向）', '其他（无意向）', '682265633886208', '2019-04-29 09:05:39', '682265633886208', '2019-04-29 09:07:48', 0);
INSERT INTO `t_dict_data` VALUES ('135093931808395264', '', '135093709900353536', 0.00, 0, '初步报价', '初步报价', '682265633886208', '2019-04-29 09:07:24', '682265633886208', '2019-04-29 09:08:29', 0);
INSERT INTO `t_dict_data` VALUES ('135094329348722688', '', '135093709900353536', 1.00, 0, '需进一步沟通', '需进一步沟通', '682265633886208', '2019-04-29 09:08:59', '682265633886208', '2019-04-29 09:08:59', 0);
INSERT INTO `t_dict_data` VALUES ('135094379885891584', '', '135093709900353536', 3.00, 0, '达成合作', '达成合作', '682265633886208', '2019-04-29 09:09:11', '682265633886208', '2019-04-29 09:09:11', 0);
INSERT INTO `t_dict_data` VALUES ('135094423489875968', '', '135093709900353536', 4.00, 0, '暂无机会', '暂无机会', '682265633886208', '2019-04-29 09:09:22', '682265633886208', '2019-04-29 09:09:22', 0);
INSERT INTO `t_dict_data` VALUES ('135094711844081664', '', '135094593044615168', 0.00, 0, '产品不符需求', '产品不符需求', '682265633886208', '2019-04-29 09:10:30', '682265633886208', '2019-04-29 09:10:30', 0);
INSERT INTO `t_dict_data` VALUES ('135094755171241984', '', '135094593044615168', 1.00, 0, '销售沟通问题', '销售沟通问题', '682265633886208', '2019-04-29 09:10:41', '682265633886208', '2019-04-29 09:10:41', 0);
INSERT INTO `t_dict_data` VALUES ('135094792290832384', '', '135094593044615168', 2.00, 0, '已有同质化产品', '已有同质化产品', '682265633886208', '2019-04-29 09:10:49', '682265633886208', '2019-04-29 09:10:49', 0);
INSERT INTO `t_dict_data` VALUES ('135094836830146560', '', '135094593044615168', 4.00, 0, '价格劣势', '价格劣势', '682265633886208', '2019-04-29 09:11:00', '682265633886208', '2019-04-29 09:11:00', 0);
INSERT INTO `t_dict_data` VALUES ('135094877628141568', '', '135094593044615168', 5.00, 0, '客户预算', '客户预算', '682265633886208', '2019-04-29 09:11:10', '682265633886208', '2019-04-29 09:11:10', 0);
INSERT INTO `t_dict_data` VALUES ('135094972272611328', '', '135094593044615168', 6.00, 0, '其他（请注明）', '其他', '682265633886208', '2019-04-29 09:11:32', '682265633886208', '2019-04-29 09:11:32', 0);
INSERT INTO `t_dict_data` VALUES ('138081428083576832', '', '82236987314016256', 0.00, 0, '报价审批表', 't_quote_audit', '682265633886208', '2019-05-07 14:58:39', '682265633886208', '2019-05-07 17:25:41', 0);
INSERT INTO `t_dict_data` VALUES ('138081523915034624', '', '82236987314016257', 0.00, 0, '报价申请表', 'quote', '682265633886208', '2019-05-07 14:59:02', '682265633886208', '2019-05-07 14:59:02', 0);
INSERT INTO `t_dict_data` VALUES ('139884502062206976', '', '82236987314016256', 1.00, 0, '合同审批表', 't_contract_audit', '682265633886208', '2019-05-12 14:23:25', '682265633886208', '2019-05-12 14:23:25', 0);
INSERT INTO `t_dict_data` VALUES ('139884586703261696', '', '82236987314016257', 1.00, 0, '合同申请表', 'contract', '682265633886208', '2019-05-12 14:23:45', '682265633886208', '2019-05-12 14:23:45', 0);
INSERT INTO `t_dict_data` VALUES ('145727113826144256', '', '131584329418543104', 2.00, 0, '10万平-20万平', '10万平-20万平', '682265633886208', '2019-05-28 17:19:52', '682265633886208', '2019-05-28 17:20:23', 0);
INSERT INTO `t_dict_data` VALUES ('145727190875508736', '', '131584329418543104', 3.00, 0, '20万平以上', '20万平以上', '682265633886208', '2019-05-28 17:20:11', '682265633886208', '2019-05-28 17:20:28', 0);
INSERT INTO `t_dict_data` VALUES ('145728493668274176', '', '145728432855060480', 0.00, 0, '一年二届', '一年二届', '682265633886208', '2019-05-28 17:25:21', '682265633886208', '2019-05-28 17:25:21', 0);
INSERT INTO `t_dict_data` VALUES ('145728527923154944', '', '145728432855060480', 1.00, 0, '一年一届', '一年一届', '682265633886208', '2019-05-28 17:25:30', '682265633886208', '2019-05-28 17:25:30', 0);
INSERT INTO `t_dict_data` VALUES ('145728559674036224', '', '145728432855060480', 2.00, 0, '二年一届', '二年一届', '682265633886208', '2019-05-28 17:25:37', '682265633886208', '2019-05-28 17:25:37', 0);
INSERT INTO `t_dict_data` VALUES ('145728594121854976', '', '145728432855060480', 4.00, 0, '其他', '其他', '682265633886208', '2019-05-28 17:25:45', '682265633886208', '2019-05-28 17:25:45', 0);
INSERT INTO `t_dict_data` VALUES ('145729217470926848', '', '145729174860992512', 0.00, 0, '已联系', '已联系', '682265633886208', '2019-05-28 17:28:14', '682265633886208', '2019-05-28 17:28:14', 0);
INSERT INTO `t_dict_data` VALUES ('145729247044964352', '', '145729174860992512', 0.00, 0, '未联系', '未联系', '682265633886208', '2019-05-28 17:28:21', '682265633886208', '2019-05-28 17:28:21', 0);
INSERT INTO `t_dict_data` VALUES ('75158227712479232', '', '75135930788220928', 0.00, 0, '男', '男', 'admin', '2018-11-14 23:44:19', 'admin', '2019-04-01 23:53:13', 0);
INSERT INTO `t_dict_data` VALUES ('75159254272577536', '', '75135930788220928', 1.00, 0, '女', '女', 'admin', '2018-11-14 23:48:24', 'admin', '2019-04-01 23:53:17', 0);
INSERT INTO `t_dict_data` VALUES ('75159898425397248', '', '75135930788220928', 2.00, -1, '保密', '保密', 'admin', '2018-11-14 23:50:57', 'admin', '2019-04-01 23:53:22', 0);
INSERT INTO `t_dict_data` VALUES ('75385648017575936', '', '75383353938808832', 0.00, 0, '系统公告', '系统公告', 'admin', '2018-11-15 14:48:00', 'admin', '2019-04-02 00:10:36', 0);
INSERT INTO `t_dict_data` VALUES ('75385706913992704', '', '75383353938808832', 1.00, 0, '提醒', '提醒', 'admin', '2018-11-15 14:48:14', 'admin', '2019-04-02 00:10:32', 0);
INSERT INTO `t_dict_data` VALUES ('75385774274514944', '', '75383353938808832', 2.00, 0, '私信', '私信', 'admin', '2018-11-15 14:48:30', 'admin', '2019-04-02 00:10:28', 0);
INSERT INTO `t_dict_data` VALUES ('75390787835138048', '', '75388696739713024', 0.00, 0, '查看操作(view)', 'view', 'admin', '2018-11-15 15:08:26', 'admin', '2018-11-15 15:08:26', 0);
INSERT INTO `t_dict_data` VALUES ('75390886501945344', '', '75388696739713024', 1.00, 0, '添加操作(add)', 'add', 'admin', '2018-11-15 15:08:49', 'admin', '2018-11-15 15:08:57', 0);
INSERT INTO `t_dict_data` VALUES ('75390993939042304', '', '75388696739713024', 2.00, 0, '编辑操作(edit)', 'edit', 'admin', '2018-11-15 15:09:15', 'admin', '2018-11-15 15:09:15', 0);
INSERT INTO `t_dict_data` VALUES ('75391067532300288', '', '75388696739713024', 3.00, 0, '删除操作(delete)', 'delete', 'admin', '2018-11-15 15:09:32', 'admin', '2018-11-15 15:09:32', 0);
INSERT INTO `t_dict_data` VALUES ('75391126902673408', '', '75388696739713024', 4.00, 0, '清空操作(clear)', 'clear', 'admin', '2018-11-15 15:09:46', 'admin', '2018-11-15 15:09:46', 0);
INSERT INTO `t_dict_data` VALUES ('75391192883269632', '', '75388696739713024', 5.00, 0, '启用操作(enable)', 'enable', 'admin', '2018-11-15 15:10:02', 'admin', '2018-11-15 15:10:02', 0);
INSERT INTO `t_dict_data` VALUES ('75391251024711680', '', '75388696739713024', 6.00, 0, '禁用操作(disable)', 'disable', 'admin', '2018-11-15 15:10:16', 'admin', '2018-11-15 15:10:16', 0);
INSERT INTO `t_dict_data` VALUES ('75391297124306944', '', '75388696739713024', 7.00, 0, '搜索操作(search)', 'search', 'admin', '2018-11-15 15:10:27', 'admin', '2018-11-15 15:10:27', 0);
INSERT INTO `t_dict_data` VALUES ('75391343379091456', '', '75388696739713024', 8.00, 0, '上传文件(upload)', 'upload', 'admin', '2018-11-15 15:10:38', 'admin', '2018-11-15 15:10:38', 0);
INSERT INTO `t_dict_data` VALUES ('75391407526776832', '', '75388696739713024', 9.00, 0, '导出操作(output)', 'output', 'admin', '2018-11-15 15:10:53', 'admin', '2018-11-15 15:10:53', 0);
INSERT INTO `t_dict_data` VALUES ('75391475042488320', '', '75388696739713024', 10.00, 0, '导入操作(input)', 'input', 'admin', '2018-11-15 15:11:09', 'admin', '2018-11-15 15:11:09', 0);
INSERT INTO `t_dict_data` VALUES ('75391522182270976', '', '75388696739713024', 11.00, 0, '分配权限(editPerm)', 'editPerm', 'admin', '2018-11-15 15:11:21', 'admin', '2018-11-15 15:11:21', 0);
INSERT INTO `t_dict_data` VALUES ('75391576364290048', '', '75388696739713024', 12.00, 0, '设为默认(setDefault)', 'setDefault', 'admin', '2018-11-15 15:11:34', 'admin', '2018-11-15 15:11:34', 0);
INSERT INTO `t_dict_data` VALUES ('75391798033256448', '', '75388696739713024', 13.00, 0, '其他操作(other)', 'other', 'admin', '2018-11-15 15:12:26', 'admin', '2018-11-15 15:12:26', 0);
INSERT INTO `t_dict_data` VALUES ('75393605291741184', '', '75392985935646720', 0.00, 0, '北京一区（华北）', 'ap-beijing-1', 'admin', '2018-11-15 15:19:37', 'admin', '2019-04-19 16:37:50', 0);
INSERT INTO `t_dict_data` VALUES ('75393681254780928', '', '75392985935646720', 1.00, 0, '北京', 'ap-beijing', 'admin', '2018-11-15 15:19:55', 'admin', '2018-11-15 15:19:55', 0);
INSERT INTO `t_dict_data` VALUES ('75393767619694592', '', '75392985935646720', 2.00, 0, '上海（华东）', 'ap-shanghai', 'admin', '2018-11-15 15:20:16', 'admin', '2018-11-15 15:20:16', 0);
INSERT INTO `t_dict_data` VALUES ('75393851484803072', '', '75392985935646720', 3.00, 0, '广州（华南）', 'ap-guangzhou', 'admin', '2018-11-15 15:20:36', 'admin', '2018-11-15 15:20:36', 0);
INSERT INTO `t_dict_data` VALUES ('75393961887272960', '', '75392985935646720', 4.00, 0, '成都（西南）', 'ap-chengdu', 'admin', '2018-11-15 15:21:02', 'admin', '2018-11-15 15:21:02', 0);
INSERT INTO `t_dict_data` VALUES ('75394053969022976', '', '75392985935646720', 5.00, 0, '重庆', 'ap-chongqing', 'admin', '2018-11-15 15:21:24', 'admin', '2018-11-15 15:21:24', 0);
INSERT INTO `t_dict_data` VALUES ('75394122474590208', '', '75392985935646720', 6.00, 0, '新加坡', 'ap-singapore', 'admin', '2018-11-15 15:21:41', 'admin', '2018-11-15 15:21:41', 0);
INSERT INTO `t_dict_data` VALUES ('75394186202845184', '', '75392985935646720', 7.00, 0, '香港', 'ap-hongkong', 'admin', '2018-11-15 15:21:56', 'admin', '2018-11-15 15:21:56', 0);
INSERT INTO `t_dict_data` VALUES ('75394254255427584', '', '75392985935646720', 8.00, 0, '多伦多', 'na-toronto', 'admin', '2018-11-15 15:22:12', 'admin', '2018-11-15 15:22:12', 0);
INSERT INTO `t_dict_data` VALUES ('75394309125312512', '', '75392985935646720', 9.00, 0, '法兰克福', 'eu-frankfurt', 'admin', '2018-11-15 15:22:25', 'admin', '2018-11-15 15:22:25', 0);
INSERT INTO `t_dict_data` VALUES ('75394367044456448', '', '75392985935646720', 10.00, 0, '孟买', 'ap-mumbai', 'admin', '2018-11-15 15:22:39', 'admin', '2018-11-15 15:22:39', 0);
INSERT INTO `t_dict_data` VALUES ('75394448523005952', '', '75392985935646720', 11.00, 0, '首尔', 'ap-seoul', 'admin', '2018-11-15 15:22:58', 'admin', '2018-11-15 15:22:58', 0);
INSERT INTO `t_dict_data` VALUES ('75394604765024256', '', '75392985935646720', 12.00, 0, '硅谷', 'na-siliconvalley', 'admin', '2018-11-15 15:23:36', 'admin', '2018-11-15 15:23:36', 0);
INSERT INTO `t_dict_data` VALUES ('75394659299364864', '', '75392985935646720', 13.00, 0, '弗吉尼亚', 'na-ashburn', 'admin', '2018-11-15 15:23:49', 'admin', '2018-11-15 15:23:49', 0);
INSERT INTO `t_dict_data` VALUES ('75394705700950016', '', '75392985935646720', 14.00, 0, '曼谷', 'ap-bangkok', 'admin', '2018-11-15 15:24:00', 'admin', '2018-11-15 15:24:00', 0);
INSERT INTO `t_dict_data` VALUES ('75394759287377920', '', '75392985935646720', 15.00, 0, '莫斯科', 'eu-moscow', 'admin', '2018-11-15 15:24:12', 'admin', '2018-11-15 15:24:12', 0);
INSERT INTO `t_dict_data` VALUES ('79717808262352896', '', '79717732567748608', 0.00, 0, '开始节点', '0', 'admin', '2018-11-27 13:42:28', 'admin', '2018-11-27 13:42:28', 0);
INSERT INTO `t_dict_data` VALUES ('79717858308788224', '', '79717732567748608', 1.00, 0, '审批节点', '1', 'admin', '2018-11-27 13:42:40', 'admin', '2018-11-27 13:42:40', 0);
INSERT INTO `t_dict_data` VALUES ('79717920061526016', '', '79717732567748608', 2.00, 0, '结束节点', '2', 'admin', '2018-11-27 13:42:54', 'admin', '2018-12-08 20:35:39', 0);
INSERT INTO `t_dict_data` VALUES ('81843987719131136', '', '81843858882695168', 0.00, 0, '普通', '0', 'admin', '2018-12-03 10:31:08', 'admin', '2018-12-03 10:31:08', 0);
INSERT INTO `t_dict_data` VALUES ('81844044015079424', '', '81843858882695168', 1.00, 0, '重要', '1', 'admin', '2018-12-03 10:31:22', 'admin', '2018-12-03 10:31:22', 0);
INSERT INTO `t_dict_data` VALUES ('81844100705292288', '', '81843858882695168', 2.00, 0, '紧急', '2', 'admin', '2018-12-03 10:31:35', 'admin', '2018-12-03 10:31:35', 0);
INSERT INTO `t_dict_data` VALUES ('82237106587439104', '', '82236987314016256', 0.00, -1, '请假申请表', 't_leave', 'admin', '2018-12-04 12:33:15', '682265633886208', '2019-05-07 18:10:32', 0);
INSERT INTO `t_dict_data` VALUES ('82237106587439105', '', '82236987314016257', 0.00, -1, '请假申请表', 'leave', 'admin', '2018-12-04 12:33:15', '682265633886208', '2019-05-07 18:10:37', 0);
INSERT INTO `t_dict_data` VALUES ('99020985985929216', '', '99020862912466944', 0.00, 0, '年假', '年假', 'admin', '2019-01-19 20:06:23', 'admin', '2019-04-01 23:55:48', 0);
INSERT INTO `t_dict_data` VALUES ('99021020739932160', '', '99020862912466944', 1.00, 0, '事假', '事假', 'admin', '2019-01-19 20:06:32', 'admin', '2019-04-01 23:55:52', 0);
INSERT INTO `t_dict_data` VALUES ('99021195566911488', '', '99020862912466944', 2.00, 0, '病假', '病假', 'admin', '2019-01-19 20:07:13', 'admin', '2019-04-01 23:55:56', 0);
INSERT INTO `t_dict_data` VALUES ('99021242476007424', '', '99020862912466944', 3.00, 0, '调休', '调休', 'admin', '2019-01-19 20:07:24', 'admin', '2019-04-01 23:56:01', 0);
INSERT INTO `t_dict_data` VALUES ('99021300730695680', '', '99020862912466944', 4.00, 0, '产假', '产假', 'admin', '2019-01-19 20:07:38', 'admin', '2019-04-01 23:56:05', 0);
INSERT INTO `t_dict_data` VALUES ('99021341889400832', '', '99020862912466944', 5.00, 0, '陪产假', '陪产假', 'admin', '2019-01-19 20:07:48', 'admin', '2019-04-01 23:56:10', 0);
INSERT INTO `t_dict_data` VALUES ('99021382393794560', '', '99020862912466944', 6.00, 0, '婚假', '婚假', 'admin', '2019-01-19 20:07:58', 'admin', '2019-04-01 23:56:14', 0);
INSERT INTO `t_dict_data` VALUES ('99021437171404800', '', '99020862912466944', 7.00, 0, '例假', '例假', 'admin', '2019-01-19 20:08:11', 'admin', '2019-04-01 23:56:18', 0);
INSERT INTO `t_dict_data` VALUES ('99021497724571648', '', '99020862912466944', 8.00, 0, '丧假', '丧假', 'admin', '2019-01-19 20:08:25', 'admin', '2019-04-01 23:56:23', 0);
INSERT INTO `t_dict_data` VALUES ('99021556704874496', '', '99020862912466944', 9.00, 0, '哺乳假', '哺乳假', 'admin', '2019-01-19 20:08:39', 'admin', '2019-04-01 23:56:27', 0);
COMMIT;

-- ----------------------------
-- Table structure for t_file
-- ----------------------------
DROP TABLE IF EXISTS `t_file`;
CREATE TABLE `t_file` (
  `id` varchar(255) NOT NULL COMMENT '主键id',
  `name` varchar(255) DEFAULT NULL COMMENT '原文件名',
  `size` bigint(20) DEFAULT NULL COMMENT '大小',
  `type` varchar(255) DEFAULT NULL COMMENT '文件类型',
  `url` varchar(255) DEFAULT NULL COMMENT '路径',
  `f_key` varchar(255) DEFAULT NULL COMMENT '存储文件名',
  `location` int(11) DEFAULT NULL COMMENT '存储位置 0本地 1七牛 2阿里 3腾讯',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_flag` int(11) DEFAULT NULL COMMENT '删除标记',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文件表';

-- ----------------------------
-- Table structure for t_github
-- ----------------------------
DROP TABLE IF EXISTS `t_github`;
CREATE TABLE `t_github` (
  `id` varchar(255) NOT NULL COMMENT '主键id',
  `avatar` varchar(255) DEFAULT NULL COMMENT '头像',
  `is_related` bit(1) DEFAULT NULL COMMENT '是否绑定账号 默认false',
  `open_id` varchar(255) DEFAULT NULL COMMENT 'github唯一id',
  `relate_username` varchar(255) DEFAULT NULL COMMENT '绑定用户账号',
  `username` varchar(255) DEFAULT NULL COMMENT '用户名',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_flag` int(11) DEFAULT NULL COMMENT '删除标记',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Github用户';

-- ----------------------------
-- Table structure for t_leave
-- ----------------------------
DROP TABLE IF EXISTS `t_leave`;
CREATE TABLE `t_leave` (
  `id` varchar(255) NOT NULL COMMENT '主键id',
  `description` varchar(255) DEFAULT NULL COMMENT '说明',
  `end_date` datetime DEFAULT NULL COMMENT '开始日期',
  `start_date` datetime DEFAULT NULL COMMENT '截止日期',
  `title` varchar(255) DEFAULT NULL COMMENT '标题',
  `duration` int(11) DEFAULT NULL COMMENT '请假时长（小时）',
  `type` varchar(255) DEFAULT NULL COMMENT '请假类型',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_flag` int(11) DEFAULT NULL COMMENT '删除标记',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='请假业务测试表';

-- ----------------------------
-- Table structure for t_log
-- ----------------------------
DROP TABLE IF EXISTS `t_log`;
CREATE TABLE `t_log` (
  `id` varchar(255) NOT NULL COMMENT '主键id',
  `name` varchar(255) DEFAULT NULL COMMENT '方法操作名称',
  `log_type` int(11) DEFAULT NULL COMMENT '日志类型 0登陆日志 1操作日志',
  `request_url` varchar(255) DEFAULT NULL COMMENT '请求路径',
  `request_type` varchar(255) DEFAULT NULL COMMENT '请求类型',
  `request_param` longtext COMMENT '请求参数',
  `username` varchar(255) DEFAULT NULL COMMENT '请求用户',
  `ip` varchar(255) DEFAULT NULL COMMENT 'ip',
  `ip_info` varchar(255) DEFAULT NULL COMMENT 'ip信息',
  `cost_time` int(11) DEFAULT NULL COMMENT '花费时间',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_flag` int(11) DEFAULT NULL COMMENT '删除标记',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='日志表';

-- ----------------------------
-- Records of t_log
-- ----------------------------
BEGIN;
INSERT INTO `t_log` VALUES ('164480376536829952', '登录系统', 1, '/highset/login', 'POST', '{\"password\":\"你是看不见我的\",\"code\":\"e8r1\",\"saveLogin\":\"true\",\"captchaId\":\"a242fbbff9234dc3875d58bc2385f40c\",\"username\":\"test\"}', 'test', '127.0.0.1', '本机地址', 1340, NULL, '2019-07-19 11:18:40', NULL, '2019-07-19 11:18:40', 0);
INSERT INTO `t_log` VALUES ('164482782435741696', '登录系统', 1, '/highset/login', 'POST', '{\"password\":\"你是看不见我的\",\"code\":\"wxdb\",\"saveLogin\":\"true\",\"captchaId\":\"f953ba2099754d0cbc24ef2246ac478e\",\"username\":\"test\"}', 'test', '127.0.0.1', '本机地址', 181, NULL, '2019-07-19 11:28:12', NULL, '2019-07-19 11:28:12', 0);
COMMIT;

-- ----------------------------
-- Table structure for t_message
-- ----------------------------
DROP TABLE IF EXISTS `t_message`;
CREATE TABLE `t_message` (
  `id` varchar(255) NOT NULL COMMENT '主键id',
  `title` varchar(255) DEFAULT NULL COMMENT '标题',
  `type` varchar(255) DEFAULT NULL COMMENT '消息类型',
  `content` longtext COMMENT '内容',
  `create_send` bit(1) DEFAULT NULL COMMENT '新创建账号也推送',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_flag` int(11) DEFAULT NULL COMMENT '删除标记',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='消息表';

-- ----------------------------
-- Records of t_message
-- ----------------------------
BEGIN;
INSERT INTO `t_message` VALUES ('1', '您收到了一条新的工作流待办消息，赶快去处理查看吧', '工作流', '<p>您收到了一条新的工作流待办消息，赶快去”工作流程-我的待办“处理查看吧</p>', NULL, 'admin', '2019-03-31 17:53:19', 'admin', '2019-03-31 17:53:19', 0);
INSERT INTO `t_message` VALUES ('2', '您有一个工作流申请已审批通过，赶快去处理查看吧', '工作流', '<p>您有一个工作流申请已审批通过，赶快去”工作流程-我的申请“处理查看吧</p>', NULL, 'admin', '2019-03-31 19:38:23', 'admin', '2019-03-31 19:38:23', 0);
INSERT INTO `t_message` VALUES ('3', '您有一个工作流申请已被驳回，赶快去处理查看吧', '工作流', '<p>您有一个工作流申请已已被驳回，赶快去”工作流程-我的申请“处理查看吧</p>', NULL, 'admin', '2019-03-31 19:42:02', 'admin', '2019-03-31 19:42:02', 0);
INSERT INTO `t_message` VALUES ('4', '您收到了一个新的被委托待办工作流任务，赶快去处理查看吧', '工作流', '<p>您收到了一个新的被委托待办工作流任务，赶快去”工作流程-我的待办“处理查看吧</p>', NULL, 'admin', '2019-03-31 19:43:17', 'admin', '2019-03-31 19:43:17', 0);
COMMIT;

-- ----------------------------
-- Table structure for t_message_send
-- ----------------------------
DROP TABLE IF EXISTS `t_message_send`;
CREATE TABLE `t_message_send` (
  `id` varchar(255) NOT NULL COMMENT '主键id',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `del_flag` int(11) DEFAULT NULL COMMENT '删除标记',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `message_id` varchar(255) DEFAULT NULL COMMENT '关联消息id',
  `status` int(11) DEFAULT NULL COMMENT '状态 0默认未读 1已读 2回收站',
  `user_id` varchar(255) DEFAULT NULL COMMENT '关联用户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='消息发送详情表';

-- ----------------------------
-- Records of t_message_send
-- ----------------------------
BEGIN;
INSERT INTO `t_message_send` VALUES ('143552839308808193', '', '2019-05-22 17:20:05', 0, '164478729748221952', '2019-07-19 11:28:23', '1', 1, '164478729748221952');
INSERT INTO `t_message_send` VALUES ('143552896401674242', '', '2019-05-22 17:20:19', 0, '164478729748221952', '2019-07-19 11:28:19', '2', 1, '164478729748221952');
INSERT INTO `t_message_send` VALUES ('143554433387597825', '', '2019-05-22 17:26:25', 0, '164478729748221952', '2019-07-19 11:28:26', '1', 2, '164478729748221952');
INSERT INTO `t_message_send` VALUES ('148885876611485696', '', '2019-06-06 10:31:40', 0, '682265633886208', '2019-06-10 13:49:27', '2', 1, '682265633886208');
INSERT INTO `t_message_send` VALUES ('148886919697141761', NULL, '2019-06-06 10:35:49', 0, NULL, '2019-06-06 10:35:49', '2', 0, '132585651357880320');
INSERT INTO `t_message_send` VALUES ('148886965024985088', NULL, '2019-06-06 10:36:00', 0, NULL, '2019-06-06 10:36:00', '1', 0, '133469391445561344');
INSERT INTO `t_message_send` VALUES ('148886988726996992', '', '2019-06-06 10:36:05', 0, '682265633886208', '2019-06-10 13:49:26', '2', 1, '682265633886208');
COMMIT;

-- ----------------------------
-- Table structure for t_permission
-- ----------------------------
DROP TABLE IF EXISTS `t_permission`;
CREATE TABLE `t_permission` (
  `id` varchar(255) NOT NULL COMMENT '主键id',
  `description` varchar(255) DEFAULT NULL COMMENT '说明备注',
  `name` varchar(255) DEFAULT NULL COMMENT '菜单/权限名称',
  `parent_id` varchar(255) DEFAULT NULL COMMENT '父id',
  `type` int(11) DEFAULT NULL COMMENT '类型 -1顶部菜单 0页面 1具体操作',
  `sort_order` decimal(10,2) DEFAULT NULL COMMENT '排序值',
  `component` varchar(255) DEFAULT NULL COMMENT '前端组件',
  `path` varchar(255) DEFAULT NULL COMMENT '页面路径/资源链接url',
  `title` varchar(255) DEFAULT NULL COMMENT '菜单标题',
  `icon` varchar(255) DEFAULT NULL COMMENT '图标',
  `level` int(11) DEFAULT NULL COMMENT '层级',
  `button_type` varchar(255) DEFAULT NULL COMMENT '按钮权限类型',
  `status` int(11) DEFAULT NULL COMMENT '是否启用 0启用 -1禁用',
  `url` varchar(255) DEFAULT NULL COMMENT '网页链接',
  `create_by` varchar(255) NOT NULL COMMENT '创建人',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_flag` int(11) DEFAULT NULL COMMENT '删除标记',
  `show_always` bit(1) DEFAULT b'1' COMMENT '始终显示 默认是',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='菜单权限表';

-- ----------------------------
-- Records of t_permission
-- ----------------------------
BEGIN;
INSERT INTO `t_permission` VALUES ('102235632889237504', NULL, 'vue-generator', '125909152017944576', 0, 3.10, 'Main', '/vue-generator', 'Vue代码生成', 'md-send', 1, NULL, 0, NULL, '682265633886209', '2019-01-28 17:00:15', 'admin', '2019-01-28 17:00:15', 0, b'1');
INSERT INTO `t_permission` VALUES ('102237605176807424', '', 'table-generator', '102235632889237504', 0, 0.00, 'highset-vue-generator/tableGenerator', 'table', '增删改表格生成', 'md-grid', 2, '', 0, '', '682265633886209', '2019-01-28 17:08:06', 'admin', '2019-02-01 20:41:31', 0, b'1');
INSERT INTO `t_permission` VALUES ('102240052523831296', '', 'tree-generator', '102235632889237504', 0, 1.00, 'highset-vue-generator/treeGenerator', 'tree', '树形结构生成', 'md-git-branch', 2, '', 0, '', '682265633886209', '2019-01-28 17:17:49', 'admin', '2019-02-01 20:41:38', 0, b'1');
INSERT INTO `t_permission` VALUES ('103658022701633536', '', 'test', '102235632889237504', 0, 3.00, 'highset-vue-generator/test', 'test', '代码生成测试页', 'ios-bug', 2, '', 0, '', '682265633886209', '2019-02-01 15:12:20', 'admin', '2019-02-01 18:38:29', 0, b'1');
INSERT INTO `t_permission` VALUES ('113601631450304512', NULL, '', '81716172680073216', 1, 2.00, '', '/highset/actTask/backAll/**', '审批驳回至发起人', '', 3, 'disable', 0, NULL, '682265633886209', '2019-03-01 01:44:41', 'admin', '2019-03-01 01:44:41', 0, b'1');
INSERT INTO `t_permission` VALUES ('113602149589454848', '', 'components', '125909152017944576', 0, 5.00, 'Main', '/components', 'Highset业务组件', 'md-cube', 1, '', 0, '', '682265633886209', '2019-03-01 01:46:44', 'admin', '2019-03-01 02:03:22', 0, b'1');
INSERT INTO `t_permission` VALUES ('113602342657462272', '', 'components', '113602149589454848', 0, 0.00, 'highset-components/highset-components', 'components', 'Highset业务组件', 'md-cube', 2, '', 0, '', '682265633886209', '2019-03-01 01:47:30', 'admin', '2019-03-01 02:03:26', 0, b'1');
INSERT INTO `t_permission` VALUES ('113603512293658624', '', 'library', '125909152017944576', 0, 6.00, 'Main', '/library', '第三方依赖工具/组件', 'ios-link', 1, '', 0, '', '682265633886209', '2019-03-01 01:52:09', 'admin', '2019-03-01 02:03:11', 0, b'1');
INSERT INTO `t_permission` VALUES ('113603617897844736', '', 'library', '113603512293658624', 0, 0.00, 'highset-library/highset-library', 'library', '第三方依赖工具/组件', 'ios-link', 2, '', 0, '', '682265633886209', '2019-03-01 01:52:34', 'admin', '2019-03-01 02:03:15', 0, b'1');
INSERT INTO `t_permission` VALUES ('117806106536841216', NULL, 'process-finish-manage', '76606430504816640', 0, 0.80, 'activiti/process-finish-manage/processFinishManage', 'process-finish-manage', '结束的流程', 'md-power', 2, '', 0, NULL, '682265633886209', '2019-03-12 16:11:46', 'admin', '2019-03-12 16:11:46', 0, b'1');
INSERT INTO `t_permission` VALUES ('121426317022334976', NULL, 'redis', '39915540965232640', 0, 2.21, 'sys/redis/redis', 'redis', 'Redis缓存管理', 'md-barcode', 2, '', 0, '', '682265633886209', '2019-03-22 15:57:11', 'admin', '2019-03-22 15:57:11', 0, b'1');
INSERT INTO `t_permission` VALUES ('125909152017944576', '', 'highset', '', -1, 0.00, '', '', 'Highset管理系统', 'md-home', 0, '', 0, '', '682265633886209', '2019-04-04 00:50:22', 'admin', '2019-04-10 21:34:38', 0, b'1');
INSERT INTO `t_permission` VALUES ('127996320085446656', NULL, 'app', NULL, -1, 2.00, NULL, NULL, 'Highset Flutter App', 'md-phone-portrait', 0, NULL, 0, NULL, '682265633886209', '2019-04-09 19:04:02', 'admin', '2019-04-09 19:04:02', 0, b'1');
INSERT INTO `t_permission` VALUES ('128364633437245440', '', 'highset-show', '', -1, 2.10, '', '', 'Highset宣传官网', 'md-paper-plane', 0, '', 0, '', '682265633886209', '2019-04-10 19:27:35', 'admin', '2019-04-10 19:27:44', 0, b'1');
INSERT INTO `t_permission` VALUES ('128366789653434368', NULL, 'flutter', '127996320085446656', 0, 0.00, 'Main', '/flutter', 'Highset Flutter App', 'md-phone-portrait', 1, '', 0, NULL, '682265633886209', '2019-04-10 19:36:09', 'admin', '2019-04-10 19:36:09', 0, b'1');
INSERT INTO `t_permission` VALUES ('128368112335589376', NULL, 'flutter', '128366789653434368', 0, 0.00, 'flutter/flutter', 'flutter', 'Highset Flutter App', 'md-phone-portrait', 2, '', 0, NULL, '682265633886209', '2019-04-10 19:41:24', 'admin', '2019-04-10 19:41:24', 0, b'1');
INSERT INTO `t_permission` VALUES ('129033675403694080', '', 'single-window', '41373430515240960', 0, 3.20, 'highset-vue-template/single-window/singleWindow', 'single-window', '动态组件单页操作', 'md-easel', 2, '', 0, '', '682265633886209', '2019-04-12 15:46:07', 'admin', '2019-04-12 15:49:08', 0, b'1');
INSERT INTO `t_permission` VALUES ('132944903872188416', '', 'highset', '128364633437245440', 0, 0.00, 'Main', '/highset', 'Highset宣传官网', 'md-paper-plane', 1, '', 0, '', '682265633886209', '2019-04-23 10:47:56', '682265633886208', '2019-04-23 11:02:09', 0, b'1');
INSERT INTO `t_permission` VALUES ('132945497533976576', NULL, 'highset', '132944903872188416', 0, 0.00, 'sys/monitor/monitor', 'highset', 'Highset宣传官网', 'md-paper-plane', 2, '', 0, 'http://www.highset.cn', '682265633886209', '2019-04-23 10:50:18', '682265633886208', '2019-04-23 10:50:18', 0, b'1');
INSERT INTO `t_permission` VALUES ('15701400130424832', '', '', '5129710648430593', 1, 1.11, '', '/highset/user/admin/add*', '添加用户', '', 3, 'add', 0, '', '682265633886209', '2018-06-03 22:04:06', '', '2018-09-19 22:16:44', 0, b'1');
INSERT INTO `t_permission` VALUES ('15701915807518720', '', '', '5129710648430593', 1, 1.13, '', '/highset/user/admin/disable/**', '禁用用户', '', 3, 'disable', 0, NULL, '682265633886209', '2018-06-03 22:06:09', '', '2018-06-06 14:46:51', 0, b'1');
INSERT INTO `t_permission` VALUES ('15708892205944832', '', '', '5129710648430593', 1, 1.14, '', '/highset/user/admin/enable/**', '启用用户', '', 3, 'enable', 0, NULL, '682265633886209', '2018-06-03 22:33:52', '', '2018-06-28 16:44:48', 0, b'1');
INSERT INTO `t_permission` VALUES ('16392452747300864', '', 'access', '125909152017944576', 0, 7.00, 'Main', '/access', '权限按钮测试页', 'md-lock', 1, '', 0, '', '682265633886209', '2018-06-05 19:50:06', 'admin', '2019-03-01 01:50:12', 0, b'1');
INSERT INTO `t_permission` VALUES ('16392767785668608', '', 'access_index', '16392452747300864', 0, 5.10, 'access/access', 'index', '权限按钮测试页', 'md-lock', 2, '', 0, '', '682265633886209', '2018-06-05 19:51:21', 'admin', '2018-10-23 12:34:38', 0, b'1');
INSERT INTO `t_permission` VALUES ('16438800255291392', '', '', '16392767785668608', 1, 5.11, '', 'test-add', '添加按钮测试', '', 3, 'add', 0, '', '682265633886209', '2018-06-05 22:54:18', 'admin', '2018-10-23 12:34:51', 0, b'1');
INSERT INTO `t_permission` VALUES ('16438962738434048', '', '', '16392767785668608', 1, 5.12, '', 'test-edit', '编辑按钮测试', '', 3, 'edit', 0, '', '682265633886209', '2018-06-05 22:54:55', 'admin', '2018-10-23 12:35:05', 0, b'1');
INSERT INTO `t_permission` VALUES ('16439068543946752', '', '', '16392767785668608', 1, 5.13, '', 'test-delete', '删除按钮测试', '', 3, 'delete', 0, '', '682265633886209', '2018-06-05 22:55:20', 'admin', '2018-10-23 12:34:54', 0, b'1');
INSERT INTO `t_permission` VALUES ('16678126574637056', '', '', '5129710648430593', 1, 1.12, '', '/highset/user/admin/edit*', '编辑用户', '', 3, 'edit', 0, '', '682265633886209', '2018-06-06 14:45:16', '', '2018-09-19 22:16:48', 0, b'1');
INSERT INTO `t_permission` VALUES ('16678447719911424', '', '', '5129710648430593', 1, 1.15, '', '/highset/user/delByIds/**', '删除用户', '', 3, 'delete', 0, '', '682265633886209', '2018-06-06 14:46:32', '', '2018-08-10 21:41:16', 0, b'1');
INSERT INTO `t_permission` VALUES ('16687383932047360', '', '', '5129710648430594', 1, 1.21, '', '/highset/role/save*', '添加角色', '', 3, 'add', 0, '', '682265633886209', '2018-06-06 15:22:03', '', '2018-09-19 22:07:34', 0, b'1');
INSERT INTO `t_permission` VALUES ('16689632049631232', '', '', '5129710648430594', 1, 1.22, '', '/highset/role/edit*', '编辑角色', '', 3, 'edit', 0, '', '682265633886209', '2018-06-06 15:30:59', '', '2018-09-19 22:07:37', 0, b'1');
INSERT INTO `t_permission` VALUES ('16689745006432256', '', '', '5129710648430594', 1, 1.23, '', '/highset/role/delAllByIds/**', '删除角色', '', 3, 'delete', 0, '', '682265633886209', '2018-06-06 15:31:26', '', '2018-08-10 21:41:23', 0, b'1');
INSERT INTO `t_permission` VALUES ('16689883993083904', NULL, NULL, '5129710648430594', 1, 1.24, NULL, '/highset/role/editRolePerm**', '分配权限', NULL, 3, 'editPerm', 0, NULL, '682265633886209', '2018-06-06 15:31:59', NULL, '2018-06-06 15:31:59', 0, b'1');
INSERT INTO `t_permission` VALUES ('16690313745666048', '', '', '5129710648430594', 1, 1.25, '', '/highset/role/setDefault*', '设为默认角色', '', 3, 'setDefault', 0, '', '682265633886209', '2018-06-06 15:33:41', '', '2018-09-19 22:07:46', 0, b'1');
INSERT INTO `t_permission` VALUES ('16694861252005888', '', '', '5129710648430595', 1, 1.31, '', '/highset/permission/add*', '添加菜单', '', 3, 'add', 0, '', '682265633886209', '2018-06-06 15:51:46', '', '2018-09-19 22:07:52', 0, b'1');
INSERT INTO `t_permission` VALUES ('16695107491205120', '', '', '5129710648430595', 1, 1.32, '', '/highset/permission/edit*', '编辑菜单', '', 3, 'edit', 0, '', '682265633886209', '2018-06-06 15:52:44', '', '2018-09-19 22:07:57', 0, b'1');
INSERT INTO `t_permission` VALUES ('16695243126607872', '', '', '5129710648430595', 1, 1.33, '', '/highset/permission/delByIds/**', '删除菜单', '', 3, 'delete', 0, '', '682265633886209', '2018-06-06 15:53:17', '', '2018-08-10 21:41:33', 0, b'1');
INSERT INTO `t_permission` VALUES ('25014528525733888', '', '', '5129710648430593', 1, 1.16, '', '无', '上传图片', '', 3, 'upload', 0, '', '682265633886209', '2018-06-29 14:51:09', '', '2018-10-08 11:13:27', 0, b'1');
INSERT INTO `t_permission` VALUES ('39915540965232640', '', 'monitor', '125909152017944576', 0, 1.50, 'Main', '/monitor', '系统监控', 'ios-analytics', 1, '', 0, '', '682265633886209', '2018-08-09 17:42:28', '682265633886208', '2019-05-24 17:47:46', 0, b'1');
INSERT INTO `t_permission` VALUES ('39916171171991552', '', 'druid', '39915540965232640', 0, 2.40, 'sys/monitor/monitor', 'druid', 'SQL监控', 'md-analytics', 2, '', 0, 'http://127.0.0.1:8888/druid/login.html', '682265633886209', '2018-08-09 17:44:57', 'admin', '2019-01-20 00:37:29', 0, b'1');
INSERT INTO `t_permission` VALUES ('39918482854252544', '', 'swagger', '39915540965232640', 0, 2.50, 'sys/monitor/monitor', 'swagger', '接口文档', 'md-document', 2, '', 0, 'http://127.0.0.1:8888/swagger-ui.html', '682265633886209', '2018-08-09 17:54:08', 'admin', '2019-01-20 00:37:41', 0, b'1');
INSERT INTO `t_permission` VALUES ('40238597734928384', NULL, 'department-manage', '5129710648430592', 0, 1.20, 'sys/department-manage/departmentManage', 'department-manage', '部门管理', 'md-git-branch', 2, '', 0, NULL, '682265633886209', '2018-08-10 15:06:10', NULL, '2018-08-10 15:06:10', 0, b'1');
INSERT INTO `t_permission` VALUES ('41363147411427328', '', 'log-manage', '39915540965232640', 0, 2.20, 'sys/log-manage/logManage', 'log-manage', '操作日志管理', 'md-list-box', 2, '', 0, '', '682265633886209', '2018-08-13 17:34:43', '', '2018-08-20 20:05:21', 0, b'1');
INSERT INTO `t_permission` VALUES ('41363537456533504', '', '', '41363147411427328', 1, 2.11, '', '/highset/log/delByIds/**', '删除日志', '', 3, 'delete', 0, '', '682265633886209', '2018-08-13 17:36:16', '', '2018-08-13 17:56:11', 0, b'1');
INSERT INTO `t_permission` VALUES ('41364927394353152', '', '', '41363147411427328', 1, 2.12, '', '/highset/log/delAll*', '清空日志', '', 3, 'undefined', 0, '', '682265633886209', '2018-08-13 17:41:48', '', '2018-09-19 22:08:57', 0, b'1');
INSERT INTO `t_permission` VALUES ('41370251991977984', NULL, 'quartz-job', '39915540965232640', 0, 2.10, 'sys/quartz-manage/quartzManage', 'quartz-job', '定时任务', 'md-time', 2, '', 0, NULL, '682265633886209', '2018-08-13 18:02:57', NULL, '2018-08-13 18:02:57', 0, b'1');
INSERT INTO `t_permission` VALUES ('41371711400054784', '', 'actuator', '39915540965232640', 0, 2.30, 'sys/actuator/actuator', 'actuator', 'Actuator监控', 'logo-angular', 2, '', 0, '', '682265633886209', '2018-08-13 18:08:45', '', '2018-08-14 12:31:15', 0, b'1');
INSERT INTO `t_permission` VALUES ('41373430515240960', '', 'vue-template', '125909152017944576', 0, 3.60, 'Main', '/vue-template', '后台Vue模版', 'ios-albums', 1, '', 0, '', '682265633886209', '2018-08-13 18:15:35', '682265633886208', '2019-05-24 17:48:37', 0, b'1');
INSERT INTO `t_permission` VALUES ('41375330996326400', '', 'simple-table', '41373430515240960', 0, 3.10, 'highset-vue-template/simple-table/simpleTable', 'simple-table', '简单表格', 'ios-grid-outline', 2, '', 0, '', '682265633886209', '2018-08-13 18:23:08', 'admin', '2018-10-20 22:47:07', 0, b'1');
INSERT INTO `t_permission` VALUES ('41376192166629376', '', 'search-table', '41373430515240960', 0, 3.40, 'highset-vue-template/search-table/searchTable', 'search-table', '搜索表格', 'md-grid', 2, '', 0, '', '682265633886209', '2018-08-13 18:26:33', 'admin', '2018-10-20 22:47:26', 0, b'1');
INSERT INTO `t_permission` VALUES ('41377034236071936', '', 'complex-table', '41373430515240960', 0, 3.50, 'highset-vue-template/complex-table/complexTable', 'complex-table', '复杂表格', 'ios-grid', 2, '', 0, '', '682265633886209', '2018-08-13 18:29:54', 'admin', '2018-10-20 22:47:33', 0, b'1');
INSERT INTO `t_permission` VALUES ('41378916912336896', '', 'tree', '41373430515240960', 0, 3.22, 'highset-vue-template/tree/tree', 'tree', '树形结构', 'ios-git-network', 2, '', 0, '', '682265633886209', '2018-08-13 18:37:23', 'admin', '2019-04-12 15:38:08', 0, b'1');
INSERT INTO `t_permission` VALUES ('41469219249852416', NULL, '', '41371711400054784', 1, 2.31, '', '无', '查看数据', '', 3, 'view', 0, NULL, '682265633886209', '2018-08-14 00:36:13', NULL, '2018-08-14 00:36:13', 0, b'1');
INSERT INTO `t_permission` VALUES ('42082442672082944', '', 'new-window', '41373430515240960', 0, 3.21, 'highset-vue-template/new-window/newWindow', 'new-window', '新窗口操作', 'ios-browsers', 2, '', 0, '', '682265633886209', '2018-08-15 17:12:57', 'admin', '2019-04-12 15:48:50', 0, b'1');
INSERT INTO `t_permission` VALUES ('42087054753927168', '', 'html-edit', '41373430515240960', 0, 3.92, 'highset-vue-template/html-edit/htmlEdit', 'html-edit', '富文本编辑', 'ios-create', 2, '', 0, '', '682265633886209', '2018-08-15 17:31:16', 'admin', '2018-10-22 21:33:53', 0, b'1');
INSERT INTO `t_permission` VALUES ('43117268627886080', '', 'message-manage', '5129710648430592', 0, 1.30, 'sys/message-manage/messageManage', 'message-manage', '消息管理', 'md-mail', 2, '', 0, '', '682265633886209', '2018-08-18 13:44:58', '', '2018-08-18 20:55:04', 0, b'1');
INSERT INTO `t_permission` VALUES ('44986029924421632', '', 'social-manage', '5129710648430592', 0, 1.50, 'sys/social-manage/socialManage', 'social-manage', '社交账号绑定', 'md-share', 2, '', 0, '', '682265633886209', '2018-08-23 17:30:46', '', '2018-09-23 23:26:53', 0, b'1');
INSERT INTO `t_permission` VALUES ('45069342940860416', '', '', '44986029924421632', 1, 1.42, '', '无', '查看社交账号数据', '', 3, 'view', 0, '', '682265633886209', '2018-08-23 23:01:49', '', '2018-08-24 10:01:09', 0, b'1');
INSERT INTO `t_permission` VALUES ('45235228800716800', '', '', '44986029924421632', 1, 1.41, '', '/highset/relate/delByIds*', '删除解绑', '', 3, 'delete', 0, '', '682265633886209', '2018-08-24 10:01:00', '', '2018-09-19 22:07:23', 0, b'1');
INSERT INTO `t_permission` VALUES ('45235621697949696', '', '', '40238597734928384', 1, 1.21, '', '/highset/department/add*', '添加部门', '', 3, 'add', 0, '', '682265633886209', '2018-08-24 10:02:33', '', '2018-09-19 22:06:57', 0, b'1');
INSERT INTO `t_permission` VALUES ('45235787867885568', '', '', '40238597734928384', 1, 1.22, '', '/highset/department/edit*', '编辑部门', '', 3, 'edit', 0, '', '682265633886209', '2018-08-24 10:03:13', '', '2018-09-19 22:07:02', 0, b'1');
INSERT INTO `t_permission` VALUES ('45235939278065664', NULL, '', '40238597734928384', 1, 1.23, '', '/highset/department/delByIds/*', '删除部门', '', 3, 'delete', 0, NULL, '682265633886209', '2018-08-24 10:03:49', NULL, '2018-08-24 10:03:49', 0, b'1');
INSERT INTO `t_permission` VALUES ('45236734832676864', '', '', '43117268627886080', 1, 1.31, '', '/highset/message/add*', '添加消息', '', 3, 'add', 0, '', '682265633886209', '2018-08-24 10:06:59', '', '2018-09-19 22:07:07', 0, b'1');
INSERT INTO `t_permission` VALUES ('45237010692050944', '', '', '43117268627886080', 1, 1.32, '', '/highset/message/edit*', '编辑消息', '', 3, 'edit', 0, '', '682265633886209', '2018-08-24 10:08:04', '', '2018-09-19 22:07:12', 0, b'1');
INSERT INTO `t_permission` VALUES ('45237170029465600', NULL, '', '43117268627886080', 1, 1.33, '', '/highset/message/delByIds/*', '删除消息', '', 3, 'delete', 0, NULL, '682265633886209', '2018-08-24 10:08:42', NULL, '2018-08-24 10:08:42', 0, b'1');
INSERT INTO `t_permission` VALUES ('45264987354042368', '', '', '41370251991977984', 1, 2.11, '', '/highset/quartzJob/add*', '添加定时任务', '', 3, 'add', 0, '', '682265633886209', '2018-08-24 11:59:14', '', '2018-09-19 22:08:11', 0, b'1');
INSERT INTO `t_permission` VALUES ('45265487029866496', '', '', '41370251991977984', 1, 2.12, '', '/highset/quartzJob/edit*', '编辑定时任务', '', 3, 'edit', 0, '', '682265633886209', '2018-08-24 12:01:14', '', '2018-09-19 22:08:17', 0, b'1');
INSERT INTO `t_permission` VALUES ('45265762415284224', '', '', '41370251991977984', 1, 2.13, '', '/highset/quartzJob/pause*', '暂停定时任务', '', 3, 'disable', 0, '', '682265633886209', '2018-08-24 12:02:19', '', '2018-09-19 22:08:24', 0, b'1');
INSERT INTO `t_permission` VALUES ('45265886315024384', '', '', '41370251991977984', 1, 2.14, '', '/highset/quartzJob/resume*', '恢复定时任务', '', 3, 'enable', 0, '', '682265633886209', '2018-08-24 12:02:49', '', '2018-09-19 22:09:13', 0, b'1');
INSERT INTO `t_permission` VALUES ('45266070000373760', NULL, '', '41370251991977984', 1, 2.15, '', '/highset/quartzJob/delByIds/*', '删除定时任务', '', 3, 'delete', 0, NULL, '682265633886209', '2018-08-24 12:03:33', NULL, '2018-08-24 12:03:33', 0, b'1');
INSERT INTO `t_permission` VALUES ('5129710648430592', '', 'sys', '125909152017944576', 0, 1.00, 'Main', '/sys', '系统管理', 'ios-settings', 1, '', 0, '', '682265633886209', '2018-06-04 19:02:29', '682265633886208', '2019-05-24 17:40:17', 0, b'1');
INSERT INTO `t_permission` VALUES ('5129710648430593', '', 'user-manage', '5129710648430592', 0, 1.10, 'sys/user-manage/userManage', 'user-manage', '用户管理', 'md-person', 2, '', 0, '', '682265633886209', '2018-06-04 19:02:32', '', '2018-08-13 15:15:33', 0, b'1');
INSERT INTO `t_permission` VALUES ('5129710648430594', '', 'role-manage', '5129710648430592', 0, 1.60, 'sys/role-manage/roleManage', 'role-manage', '角色权限管理', 'md-contacts', 2, '', 0, '', '682265633886209', '2018-06-04 19:02:35', '', '2018-10-13 13:51:36', 0, b'1');
INSERT INTO `t_permission` VALUES ('5129710648430595', '', 'menu-manage', '5129710648430592', 0, 1.70, 'sys/menu-manage/menuManage', 'menu-manage', '菜单权限管理', 'md-menu', 2, '', 0, '', '682265633886209', '2018-06-04 19:02:37', '', '2018-09-23 23:32:02', 0, b'1');
INSERT INTO `t_permission` VALUES ('56309618086776832', '', 'oss-manage', '5129710648430592', 0, 1.40, 'sys/oss-manage/ossManage', 'oss-manage', '文件对象存储', 'ios-folder', 2, '', 0, '', '682265633886209', '2018-09-23 23:26:40', 'admin', '2018-11-15 15:17:43', 0, b'1');
INSERT INTO `t_permission` VALUES ('56898976661639168', '', '', '5129710648430593', 1, 1.17, '', '/highset/user/importData*', '导入用户', '', 3, 'input', 0, '', '682265633886209', '2018-09-25 14:28:34', '', '2018-09-25 15:12:46', 0, b'1');
INSERT INTO `t_permission` VALUES ('56911328312299520', '', 'excel', '41373430515240960', 0, 3.60, 'highset-vue-template/excel/excel', 'excel', 'Excel导入导出', 'md-exit', 2, '', 0, '', '682265633886209', '2018-09-25 15:17:39', 'admin', '2018-10-20 22:47:36', 0, b'1');
INSERT INTO `t_permission` VALUES ('57009544286441472', NULL, '', '43117268627886080', 1, 1.40, '', '/highset/messageSend/save*', '添加已发送消息', '', 3, 'add', 0, NULL, '682265633886209', '2018-09-25 21:47:55', NULL, '2018-09-25 21:47:55', 0, b'1');
INSERT INTO `t_permission` VALUES ('57009744761589760', NULL, '', '43117268627886080', 1, 1.50, '', '/highset/messageSend/update*', '编辑已发送消息', '', 3, 'edit', 0, NULL, '682265633886209', '2018-09-25 21:48:43', NULL, '2018-09-25 21:48:43', 0, b'1');
INSERT INTO `t_permission` VALUES ('57009981228060672', NULL, '', '43117268627886080', 1, 1.60, '', '/highset/messageSend/delByIds/*', '删除已发送消息', '', 3, 'delete', 0, NULL, '682265633886209', '2018-09-25 21:49:39', NULL, '2018-09-25 21:49:39', 0, b'1');
INSERT INTO `t_permission` VALUES ('57212882168844288', '', '', '56309618086776832', 1, 1.41, '', '无', '上传文件', '', 3, 'upload', 0, '', '682265633886209', '2018-09-26 11:15:55', '', '2018-10-08 11:10:05', 0, b'1');
INSERT INTO `t_permission` VALUES ('58480609315524608', '', 'setting', '5129710648430592', 0, 1.90, 'sys/setting-manage/settingManage', 'setting', '系统配置', 'ios-settings-outline', 2, '', 0, '', '682265633886209', '2018-09-29 23:13:24', 'admin', '2018-11-14 13:24:26', 0, b'1');
INSERT INTO `t_permission` VALUES ('61394706252173312', NULL, '', '58480609315524608', 1, 1.81, '', '/highset/setting/seeSecret/**', '查看私密配置', '', 3, 'view', 0, NULL, '682265633886209', '2018-10-08 00:12:59', NULL, '2018-10-08 00:12:59', 0, b'1');
INSERT INTO `t_permission` VALUES ('61417744146370560', '', '', '58480609315524608', 1, 1.82, '', '/highset/setting/*/set*', '编辑配置', '', 3, 'edit', 0, '', '682265633886209', '2018-10-08 01:44:32', '', '2018-10-08 01:50:03', 0, b'1');
INSERT INTO `t_permission` VALUES ('61560041605435392', NULL, '', '56309618086776832', 1, 1.42, '', '/highset/file/rename*', '重命名文件', '', 3, 'edit', 0, NULL, '682265633886209', '2018-10-08 11:09:58', NULL, '2018-10-08 11:09:58', 0, b'1');
INSERT INTO `t_permission` VALUES ('61560275261722624', NULL, '', '56309618086776832', 1, 1.43, '', '/highset/file/copy*', '复制文件', '', 3, 'edit', 0, NULL, '682265633886209', '2018-10-08 11:10:54', NULL, '2018-10-08 11:10:54', 0, b'1');
INSERT INTO `t_permission` VALUES ('61560480518377472', NULL, '', '56309618086776832', 1, 1.44, '', '/highset/file/delete/*', '删除文件', '', 3, 'delete', 0, NULL, '682265633886209', '2018-10-08 11:11:43', NULL, '2018-10-08 11:11:43', 0, b'1');
INSERT INTO `t_permission` VALUES ('63482475359244288', '', 'custom-tree', '41373430515240960', 0, 3.80, 'highset-vue-template/custom-tree/customTree', 'custom-tree', '自定义树', 'md-git-network', 2, '', 0, '', '682265633886209', '2018-10-13 18:29:02', 'admin', '2018-10-20 22:47:45', 0, b'1');
INSERT INTO `t_permission` VALUES ('63741744973352960', '', 'render', '41373430515240960', 0, 3.30, 'highset-vue-template/render/render', 'render', 'Render函数示例', 'md-aperture', 2, '', 0, '', '682265633886209', '2018-10-14 11:39:17', 'admin', '2019-02-04 17:03:07', 0, b'1');
INSERT INTO `t_permission` VALUES ('64290663792906240', '', 'tree&table', '41373430515240960', 0, 3.90, 'highset-vue-template/tree&table/tree&table', 'tree&table', '树+表格', 'md-list', 2, '', 0, '', '682265633886209', '2018-10-16 00:00:29', 'admin', '2018-10-20 22:47:49', 0, b'1');
INSERT INTO `t_permission` VALUES ('66790433014943744', '', 'card-list', '41373430515240960', 0, 3.91, 'highset-vue-template/card-list/cardList', 'card-list', '卡片列表', 'md-card', 2, '', 0, '', '682265633886209', '2018-10-22 21:33:42', 'admin', '2018-10-22 21:37:12', 0, b'1');
INSERT INTO `t_permission` VALUES ('67027338952445952', '', 'product-template', '125909152017944576', 0, 4.00, 'Main', '/product-template', '前台产品级组件', 'md-ribbon', 1, '', 0, '', '682265633886209', '2018-10-23 13:15:03', 'admin', '2018-10-23 14:57:38', 0, b'1');
INSERT INTO `t_permission` VALUES ('67027909637836800', '', 'banner', '67027338952445952', 0, 4.10, 'product-template/banner/Banner', 'banner', '轮播组件', 'md-book', 2, '', 0, '', '682265633886209', '2018-10-23 13:17:19', 'admin', '2018-10-23 14:57:46', 0, b'1');
INSERT INTO `t_permission` VALUES ('67042515441684480', '', 'product', '67027338952445952', 0, 4.20, 'product-template/product/Product', 'product', '产品组件', 'md-pricetags', 2, '', 0, '', '682265633886209', '2018-10-23 14:15:22', 'admin', '2018-10-23 14:57:51', 0, b'1');
INSERT INTO `t_permission` VALUES ('67082402312228864', NULL, 'category', '67027338952445952', 0, 4.30, 'product-template/category/Category', 'category', '分类栏组件', 'md-apps', 2, '', 0, NULL, '682265633886209', '2018-10-23 16:53:53', 'admin', '2018-10-23 16:53:53', 0, b'1');
INSERT INTO `t_permission` VALUES ('75002207560273920', '', 'dict', '5129710648430592', 0, 1.80, 'sys/dict-manage/dictManage', 'dict', '数据字典管理', 'md-bookmarks', 2, '', 0, '', '682265633886209', '2018-11-14 13:24:21', 'admin', '2018-11-20 20:06:22', 0, b'1');
INSERT INTO `t_permission` VALUES ('76215889006956544', '', '', '75002207560273920', 1, 1.81, '', '/highset/dict/add*', '添加字典', '', 3, 'add', 0, '', '682265633886209', '2018-11-17 21:47:05', 'admin', '2018-11-17 21:47:53', 0, b'1');
INSERT INTO `t_permission` VALUES ('76216071333351424', NULL, '', '75002207560273920', 1, 1.82, '', '/highset/dict/edit*', '编辑字典', '', 3, 'edit', 0, NULL, '682265633886209', '2018-11-17 21:47:48', 'admin', '2018-11-17 21:47:48', 0, b'1');
INSERT INTO `t_permission` VALUES ('76216264070008832', NULL, '', '75002207560273920', 1, 1.83, '', '/highset/dict/delByIds/**', '删除字典', '', 3, 'delete', 0, NULL, '682265633886209', '2018-11-17 21:48:34', 'admin', '2018-11-17 21:48:34', 0, b'1');
INSERT INTO `t_permission` VALUES ('76216459709124608', NULL, '', '75002207560273920', 1, 1.84, '', '/highset/dictData/add*', '添加字典数据', '', 3, 'add', 0, NULL, '682265633886209', '2018-11-17 21:49:21', 'admin', '2018-11-17 21:49:21', 0, b'1');
INSERT INTO `t_permission` VALUES ('76216594207870976', NULL, '', '75002207560273920', 1, 1.85, '', '/highset/dictData/edit*', '编辑字典数据', '', 3, 'edit', 0, NULL, '682265633886209', '2018-11-17 21:49:53', 'admin', '2018-11-17 21:49:53', 0, b'1');
INSERT INTO `t_permission` VALUES ('76216702639017984', NULL, '', '75002207560273920', 1, 1.86, '', '/highset/dictData/delByIds/**', '删除字典数据', '', 3, 'delete', 0, NULL, '682265633886209', '2018-11-17 21:50:18', 'admin', '2018-11-17 21:50:18', 0, b'1');
INSERT INTO `t_permission` VALUES ('76606430504816640', '', 'activiti', '125909152017944576', 0, 2.10, 'Main', '/activiti', '工作流程', 'md-git-compare', 1, '', 0, '', '682265633886209', '2018-11-18 23:38:57', '682265633886209', '2019-04-19 19:12:48', 0, b'1');
INSERT INTO `t_permission` VALUES ('76607201262702592', '', 'model-manage', '76606430504816640', 0, 1.00, 'activiti/model-manage/modelManage', 'model-manage', '模型管理', 'md-cube', 2, '', 0, '', '682265633886209', '2018-11-18 23:42:01', 'admin', '2018-11-20 19:41:58', 0, b'1');
INSERT INTO `t_permission` VALUES ('76914082455752704', '', 'process-manage', '76606430504816640', 0, 0.90, 'activiti/process-manage/processManage', 'process-manage', '流程管理', 'md-calendar', 2, '', 0, '', '682265633886209', '2018-11-19 20:01:28', 'admin', '2018-11-20 19:41:50', 0, b'1');
INSERT INTO `t_permission` VALUES ('80539147005071360', '', 'category-manage', '76606430504816640', 0, 2.00, 'activiti/category-manage/categoryManage', 'category-manage', '流程分类管理', 'md-bookmark', 2, '', 0, '', '682265633886209', '2018-11-29 20:06:10', 'admin', '2018-12-04 14:14:41', 0, b'1');
INSERT INTO `t_permission` VALUES ('81319435670917120', '', 'process-ins-manage', '76606430504816640', 0, 0.70, 'activiti/process-ins-manage/processInsManage', 'process-ins-manage', '运行中的流程', 'md-fastforward', 2, '', 0, '', '682265633886209', '2018-12-01 23:46:45', 'admin', '2018-12-02 15:37:03', 0, b'1');
INSERT INTO `t_permission` VALUES ('81558529864896512', '', 'apply-manage', '76606430504816640', 0, 0.00, 'activiti/apply-manage/applyManage', 'apply-manage', '我的申请', 'md-clipboard', 2, '', 0, '', '682265633886209', '2018-12-02 15:36:50', 'admin', '2018-12-08 14:50:38', 0, b'1');
INSERT INTO `t_permission` VALUES ('81716172680073216', NULL, 'todo-manage', '76606430504816640', 0, 0.10, 'activiti/todo-manage/todoManage', 'todo-manage', '我的待办', 'ios-pricetag', 2, '', 0, NULL, '682265633886209', '2018-12-03 02:03:15', 'admin', '2018-12-03 02:03:15', 0, b'1');
INSERT INTO `t_permission` VALUES ('82269650301227008', NULL, 'done-manage', '76606430504816640', 0, 0.20, 'activiti/done-manage/doneManage', 'done-manage', '我的已办', 'ios-pricetag-outline', 2, '', 0, NULL, '682265633886209', '2018-12-04 14:42:34', 'admin', '2018-12-04 14:42:34', 0, b'1');
INSERT INTO `t_permission` VALUES ('84082369492946944', '', '', '81558529864896512', 1, 0.00, '', '/highset/leave/add*', '添加请假申请', '', 3, 'add', 0, '', '682265633886209', '2018-12-09 14:45:40', 'admin', '2018-12-09 14:46:59', 0, b'1');
INSERT INTO `t_permission` VALUES ('84082920431554560', NULL, '', '81558529864896512', 1, 1.00, '', '/highset/actBusiness/delByIds/**', '删除草稿申请', '', 3, 'delete', 0, NULL, '682265633886209', '2018-12-09 14:47:51', 'admin', '2018-12-09 14:47:51', 0, b'1');
INSERT INTO `t_permission` VALUES ('84083562503999488', NULL, '', '81716172680073216', 1, 0.00, '', '/highset/actTask/pass**', '审批通过', '', 3, 'enable', 0, NULL, '682265633886209', '2018-12-09 14:50:25', 'admin', '2018-12-09 14:50:25', 0, b'1');
INSERT INTO `t_permission` VALUES ('84083641302388736', NULL, '', '81716172680073216', 1, 1.00, '', '/highset/actTask/back**', '审批驳回', '', 3, 'disable', 0, NULL, '682265633886209', '2018-12-09 14:50:43', 'admin', '2018-12-09 14:50:43', 0, b'1');
INSERT INTO `t_permission` VALUES ('84084404707659776', NULL, '', '81716172680073216', 1, 3.00, '', '/highset/actTask/delegate**', '委托代办', '', 3, 'other', 0, NULL, '682265633886209', '2018-12-09 14:53:45', 'admin', '2018-12-09 14:53:45', 0, b'1');
INSERT INTO `t_permission` VALUES ('84084724590448640', NULL, '', '82269650301227008', 1, 0.00, '', '/highset/actTask/deleteHistoric/**', '删除已办任务', '', 3, 'delete', 0, NULL, '682265633886209', '2018-12-09 14:55:02', 'admin', '2018-12-09 14:55:02', 0, b'1');
INSERT INTO `t_permission` VALUES ('84084965817454592', NULL, '', '81319435670917120', 1, 0.00, '', '/highset/actProcess/delInsByIds/**', '删除运行流程', '', 3, 'delete', 0, NULL, '682265633886209', '2018-12-09 14:55:59', 'admin', '2018-12-09 14:55:59', 0, b'1');
INSERT INTO `t_permission` VALUES ('84085542324539392', NULL, '', '76914082455752704', 1, 0.00, '', '/highset/actProcess/updateInfo/**', '编辑流程信息', '', 3, 'edit', 0, NULL, '682265633886209', '2018-12-09 14:58:17', 'admin', '2018-12-09 14:58:17', 0, b'1');
INSERT INTO `t_permission` VALUES ('84085810797744128', NULL, '', '76914082455752704', 1, 1.00, '', '/highset/actProcess/editNodeUser**', '流程节点设置', '', 3, 'edit', 0, NULL, '682265633886209', '2018-12-09 14:59:21', 'admin', '2018-12-09 14:59:21', 0, b'1');
INSERT INTO `t_permission` VALUES ('84085980943880192', NULL, '', '76914082455752704', 1, 2.00, '', '/highset/actProcess/convertToModel/**', '流程转模型', '', 3, 'other', 0, NULL, '682265633886209', '2018-12-09 15:00:01', 'admin', '2018-12-09 15:00:01', 0, b'1');
INSERT INTO `t_permission` VALUES ('84086163001839616', '', '', '76914082455752704', 1, 3.00, '', '/highset/actProcess/delByIds/**', '删除流程定义', '', 3, 'delete', 0, '', '682265633886209', '2018-12-09 15:00:45', 'admin', '2018-12-09 15:01:37', 0, b'1');
INSERT INTO `t_permission` VALUES ('84086362248056832', NULL, '', '76914082455752704', 1, 4.00, '', '/highset/actModel/deployByFile**', '文件部署流程', '', 3, 'other', 0, NULL, '682265633886209', '2018-12-09 15:01:32', 'admin', '2018-12-09 15:01:32', 0, b'1');
INSERT INTO `t_permission` VALUES ('84086882907983872', NULL, '', '76607201262702592', 1, 0.00, '', '/highset/actModel/add**', '添加模型', '', 3, 'add', 0, NULL, '682265633886209', '2018-12-09 15:03:36', 'admin', '2018-12-09 15:03:36', 0, b'1');
INSERT INTO `t_permission` VALUES ('84087009940869120', NULL, '', '76607201262702592', 1, 1.00, '', '/highset/actModel/delByIds/**', '删除模型', '', 3, 'delete', 0, NULL, '682265633886209', '2018-12-09 15:04:06', 'admin', '2018-12-09 15:04:06', 0, b'1');
INSERT INTO `t_permission` VALUES ('84087154040377344', NULL, '', '76607201262702592', 1, 2.00, '', '/highset/actModel/deploy/**', '部署模型', '', 3, 'other', 0, NULL, '682265633886209', '2018-12-09 15:04:41', 'admin', '2018-12-09 15:04:41', 0, b'1');
INSERT INTO `t_permission` VALUES ('84087344352727040', '', '', '80539147005071360', 1, 0.00, '', '/highset/actCategory/add**', '添加流程分类', '', 3, 'add', 0, '', '682265633886209', '2018-12-09 15:05:26', 'admin', '2018-12-09 15:05:33', 0, b'1');
INSERT INTO `t_permission` VALUES ('84087480852156416', NULL, '', '80539147005071360', 1, 1.00, '', '/highset/actCategory/edit**', '编辑流程分类', '', 3, 'edit', 0, NULL, '682265633886209', '2018-12-09 15:05:59', 'admin', '2018-12-09 15:05:59', 0, b'1');
INSERT INTO `t_permission` VALUES ('84087593041399808', NULL, '', '80539147005071360', 1, 2.00, '', '/highset/actCategory/delByIds/**', '删除流程分类', '', 3, 'delete', 0, NULL, '682265633886209', '2018-12-09 15:06:25', 'admin', '2018-12-09 15:06:25', 0, b'1');
COMMIT;

-- ----------------------------
-- Table structure for t_province
-- ----------------------------
DROP TABLE IF EXISTS `t_province`;
CREATE TABLE `t_province` (
  `id` varchar(32) NOT NULL COMMENT '主键id',
  `label` varchar(30) DEFAULT NULL COMMENT '省份',
  `sort_order` decimal(10,2) DEFAULT NULL COMMENT '排序',
  `del_flag` int(11) NOT NULL DEFAULT '0' COMMENT '删除标志',
  `create_by` varchar(32) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `del_flag` (`del_flag`),
  KEY `sort_order` (`sort_order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='省份';

-- ----------------------------
-- Records of t_province
-- ----------------------------
BEGIN;
INSERT INTO `t_province` VALUES ('1', '北京市', 99.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('10', '黑龙江省', 97.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('11', '江苏省', 78.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('12', '浙江省', 72.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('13', '安徽省', 79.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('14', '福建省', 71.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('15', '江西省', 73.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('16', '山东省', 81.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('17', '河南省', 80.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('18', '湖北省', 75.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('19', '湖南省', 74.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('2', '天津市', 98.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('20', '广东省', 68.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('21', '广西', 69.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('22', '海南省', 67.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('23', '四川省', 87.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('24', '贵州省', 85.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('25', '云南省', 84.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('26', '西藏自治区', 88.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('27', '陕西省', 89.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('28', '甘肃省', 91.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('29', '青海省', 90.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('3', '上海市', 76.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('30', '宁夏', 92.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('31', '新疆自治区', 93.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('32', '台湾省', 70.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('33', '香港特别行政区', 66.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('34', '澳门特别行政区', 65.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('4', '重庆市', 86.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('5', '河北省', 82.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('6', '山西省', 83.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('7', '内蒙古', 94.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('8', '辽宁省', 95.00, 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_province` VALUES ('9', '吉林省', 96.00, 0, NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_qq
-- ----------------------------
DROP TABLE IF EXISTS `t_qq`;
CREATE TABLE `t_qq` (
  `id` varchar(255) NOT NULL COMMENT '主键id',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `del_flag` int(11) DEFAULT NULL COMMENT '删除标记',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `avatar` varchar(255) DEFAULT NULL COMMENT '头像',
  `is_related` bit(1) DEFAULT NULL COMMENT '是否绑定账号 默认false',
  `open_id` varchar(255) DEFAULT NULL COMMENT 'qq唯一id',
  `relate_username` varchar(255) DEFAULT NULL COMMENT '绑定用户账号',
  `username` varchar(255) DEFAULT NULL COMMENT '用户名',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='QQ用户表';

-- ----------------------------
-- Table structure for t_quartz_job
-- ----------------------------
DROP TABLE IF EXISTS `t_quartz_job`;
CREATE TABLE `t_quartz_job` (
  `id` varchar(255) NOT NULL COMMENT '主键id',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `del_flag` int(11) DEFAULT NULL COMMENT '删除标记',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `cron_expression` varchar(255) DEFAULT NULL COMMENT 'cron表达式',
  `description` varchar(255) DEFAULT NULL COMMENT '备注',
  `job_class_name` varchar(255) DEFAULT NULL COMMENT '任务类名',
  `parameter` varchar(255) DEFAULT NULL COMMENT '参数',
  `status` int(11) DEFAULT NULL COMMENT '状态 0正常 -1停止',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='定时任务表';

-- ----------------------------
-- Table structure for t_role
-- ----------------------------
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role` (
  `id` varchar(255) NOT NULL COMMENT '主键id',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `name` varchar(255) DEFAULT NULL COMMENT '角色名 以ROLE_开头',
  `del_flag` int(11) DEFAULT NULL COMMENT '删除标记',
  `default_role` bit(1) DEFAULT NULL COMMENT '是否为注册默认角色',
  `description` varchar(255) DEFAULT NULL COMMENT '备注',
  `data_type` int(11) DEFAULT NULL COMMENT '数据权限类型 0全部默认 1自定义',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色表';

-- ----------------------------
-- Records of t_role
-- ----------------------------
BEGIN;
INSERT INTO `t_role` VALUES ('496138616573952', '', '2018-04-22 23:03:49', 'admin', '2018-11-15 23:02:59', 'ROLE_ADMIN', 0, NULL, '超级管理员 拥有所有权限', 0);
INSERT INTO `t_role` VALUES ('496138616573953', '', '2018-05-02 21:40:03', 'admin', '2018-11-01 22:59:48', 'ROLE_USER', 0, b'1', '普通注册用户 路过看看', 0);
COMMIT;

-- ----------------------------
-- Table structure for t_role_department
-- ----------------------------
DROP TABLE IF EXISTS `t_role_department`;
CREATE TABLE `t_role_department` (
  `id` varchar(255) NOT NULL COMMENT '主键id',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `del_flag` int(11) DEFAULT NULL COMMENT '删除标记',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `department_id` varchar(255) DEFAULT NULL COMMENT '部门id',
  `role_id` varchar(255) DEFAULT NULL COMMENT '角色id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色部门关系表';

-- ----------------------------
-- Table structure for t_role_permission
-- ----------------------------
DROP TABLE IF EXISTS `t_role_permission`;
CREATE TABLE `t_role_permission` (
  `id` varchar(255) NOT NULL COMMENT '主键id',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人\r\n',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `del_flag` int(11) DEFAULT NULL COMMENT '删除标记',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `permission_id` varchar(255) DEFAULT NULL COMMENT '权限id',
  `role_id` varchar(255) DEFAULT NULL COMMENT '角色id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色权限关系表';

-- ----------------------------
-- Records of t_role_permission
-- ----------------------------
BEGIN;
INSERT INTO `t_role_permission` VALUES ('164477222952898560', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '125909152017944576', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223208751104', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '5129710648430592', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223217139712', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '5129710648430593', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223229722624', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '15701400130424832', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223242305536', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '16678126574637056', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223254888448', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '15701915807518720', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223267471360', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '15708892205944832', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223280054272', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '16678447719911424', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223288442880', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '25014528525733888', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223301025792', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '56898976661639168', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223313608704', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '40238597734928384', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223326191616', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '45235621697949696', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223334580224', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '45235787867885568', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223347163136', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '45235939278065664', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223359746048', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '43117268627886080', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223368134656', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '45236734832676864', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223380717568', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '45237010692050944', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223393300480', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '45237170029465600', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223405883392', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '57009544286441472', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223418466304', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '57009744761589760', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223426854912', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '57009981228060672', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223439437824', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '56309618086776832', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223447826432', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '57212882168844288', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223460409344', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '61560041605435392', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223472992256', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '61560275261722624', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223481380864', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '61560480518377472', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223493963776', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '44986029924421632', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223506546688', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '45235228800716800', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223519129600', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '45069342940860416', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223531712512', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '5129710648430594', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223540101120', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '16687383932047360', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223552684032', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '16689632049631232', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223565266944', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '16689745006432256', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223577849856', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '16689883993083904', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223586238464', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '16690313745666048', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223598821376', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '5129710648430595', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223611404288', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '16694861252005888', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223619792896', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '16695107491205120', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223632375808', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '16695243126607872', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223640764416', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '75002207560273920', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223653347328', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '76215889006956544', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223665930240', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '76216071333351424', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223674318848', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '76216264070008832', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223686901760', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '76216459709124608', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223699484672', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '76216594207870976', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223707873280', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '76216702639017984', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223720456192', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '58480609315524608', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223733039104', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '61394706252173312', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223741427712', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '61417744146370560', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223754010624', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '39915540965232640', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223766593536', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '41370251991977984', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223774982144', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '45264987354042368', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223787565056', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '45265487029866496', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223795953664', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '45265762415284224', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223808536576', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '45265886315024384', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223821119488', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '45266070000373760', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223833702400', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '41363147411427328', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223842091008', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '41363537456533504', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223854673920', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '41364927394353152', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223863062528', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '121426317022334976', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223875645440', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '41371711400054784', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223888228352', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '41469219249852416', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223900811264', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '39916171171991552', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223913394176', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '39918482854252544', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223921782784', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '76606430504816640', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223934365696', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '81558529864896512', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223942754304', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '84082369492946944', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223955337216', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '84082920431554560', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223967920128', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '81716172680073216', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223976308736', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '84083562503999488', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223984697344', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '84083641302388736', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477223997280256', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '113601631450304512', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224005668864', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '84084404707659776', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224014057472', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '82269650301227008', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224026640384', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '84084724590448640', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224035028992', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '81319435670917120', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224043417600', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '84084965817454592', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224056000512', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '117806106536841216', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224064389120', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '76914082455752704', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224072777728', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '84085542324539392', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224085360640', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '84085810797744128', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224097943552', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '84085980943880192', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224106332160', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '84086163001839616', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224118915072', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '84086362248056832', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224127303680', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '76607201262702592', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224135692288', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '84086882907983872', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224148275200', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '84087009940869120', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224156663808', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '84087154040377344', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224165052416', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '80539147005071360', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224177635328', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '84087344352727040', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224186023936', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '84087480852156416', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224198606848', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '84087593041399808', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224206995456', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '102235632889237504', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224215384064', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '102237605176807424', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224227966976', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '102240052523831296', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224236355584', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '103658022701633536', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224248938496', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '41373430515240960', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224257327104', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '41375330996326400', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224265715712', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '129033675403694080', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224278298624', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '42082442672082944', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224286687232', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '41378916912336896', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224295075840', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '63741744973352960', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224303464448', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '41376192166629376', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224316047360', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '41377034236071936', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224324435968', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '56911328312299520', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224332824576', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '63482475359244288', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224341213184', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '64290663792906240', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224353796096', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '66790433014943744', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224362184704', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '42087054753927168', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224374767616', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '67027338952445952', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224383156224', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '67027909637836800', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224391544832', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '67042515441684480', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224399933440', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '67082402312228864', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224412516352', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '113602149589454848', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224420904960', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '113602342657462272', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224429293568', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '113603512293658624', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224437682176', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '113603617897844736', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224446070784', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '16392452747300864', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224458653696', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '16392767785668608', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224467042304', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '16438800255291392', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224475430912', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '16438962738434048', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224488013824', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '16439068543946752', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224496402432', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '127996320085446656', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224504791040', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '128366789653434368', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224517373952', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '128368112335589376', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224525762560', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '128364633437245440', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224534151168', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '132944903872188416', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164477224542539776', '682265633886208', '2019-07-19 11:06:07', 0, '682265633886208', '2019-07-19 11:06:07', '132945497533976576', '496138616573952');
INSERT INTO `t_role_permission` VALUES ('164482684226113536', '682265633886208', '2019-07-19 11:27:49', 0, '682265633886208', '2019-07-19 11:27:49', '57009744761589760', '496138616573953');
INSERT INTO `t_role_permission` VALUES ('164482684268056576', '682265633886208', '2019-07-19 11:27:49', 0, '682265633886208', '2019-07-19 11:27:49', '57009981228060672', '496138616573953');
COMMIT;

-- ----------------------------
-- Table structure for t_setting
-- ----------------------------
DROP TABLE IF EXISTS `t_setting`;
CREATE TABLE `t_setting` (
  `id` varchar(255) NOT NULL,
  `create_by` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `del_flag` int(11) DEFAULT NULL,
  `update_by` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `value` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_setting
-- ----------------------------
BEGIN;
INSERT INTO `t_setting` VALUES ('ALI_SMS', '682265633886208', '2019-07-01 17:11:37', 0, '682265633886208', '2019-07-01 17:11:37', '{\"serviceName\":\"ALI_SMS\",\"accessKey\":\"LTAIylfuKezpbGNb\",\"secretKey\":\"Kkw2ybf3dICDHsJWCGDEYRNgn6jyFp\",\"signName\":\"昊商易通\",\"changed\":true}');
INSERT INTO `t_setting` VALUES ('ALI_SMS_ACTIVITI', '682265633886208', '2019-07-01 17:14:48', 0, '682265633886208', '2019-07-01 17:14:48', 'SMS_165385489');
INSERT INTO `t_setting` VALUES ('ALI_SMS_CHANGE_MOBILE', '682265633886208', '2019-07-01 17:14:18', 0, '682265633886208', '2019-07-01 17:14:18', 'SMS_165380502');
INSERT INTO `t_setting` VALUES ('ALI_SMS_CHANG_PASS', '682265633886208', '2019-07-01 17:14:28', 0, '682265633886208', '2019-07-01 17:14:28', 'SMS_165380500');
INSERT INTO `t_setting` VALUES ('ALI_SMS_COMMON', '682265633886208', '2019-07-01 17:11:37', 0, '682265633886208', '2019-07-01 17:11:37', 'SMS_165385461');
INSERT INTO `t_setting` VALUES ('ALI_SMS_LOGIN', '682265633886208', '2019-07-01 17:13:52', 0, '682265633886208', '2019-07-01 17:13:52', 'SMS_165385466');
INSERT INTO `t_setting` VALUES ('ALI_SMS_REGIST', '682265633886208', '2019-07-01 17:12:27', 0, '682265633886208', '2019-07-01 17:12:27', 'SMS_165380489');
INSERT INTO `t_setting` VALUES ('ALI_SMS_RESET_PASS', '682265633886208', '2019-07-01 17:14:39', 0, '682265633886208', '2019-07-01 17:14:39', 'SMS_165385470');
INSERT INTO `t_setting` VALUES ('EMAIL_SETTING', '682265633886208', '2019-07-01 17:15:37', 0, '682265633886208', '2019-07-01 18:29:58', '{\"host\":\"smtpdm.aliyun.com\",\"username\":\"highset@email.highset.cn\",\"password\":\"joTPhgFyBXucL5N4\",\"changed\":false}');
INSERT INTO `t_setting` VALUES ('LOCAL_OSS', '682265633886208', '2019-07-01 17:26:53', 0, '682265633886208', '2019-07-01 17:26:53', '{\"serviceName\":\"LOCAL_OSS\",\"endpoint\":\"127.0.0.1:9999/highset/file/view\",\"http\":\"http://\",\"filePath\":\"/Users/victor/projectUpload/highset-crm\"}');
INSERT INTO `t_setting` VALUES ('OSS_USED', '682265633886208', '2019-07-01 17:26:53', 0, '682265633886208', '2019-07-01 17:26:53', 'LOCAL_OSS');
INSERT INTO `t_setting` VALUES ('OTHER_SETTING', '682265633886208', '2019-07-01 18:26:28', 0, '682265633886208', '2019-07-01 18:26:28', '{\"domain\":\"http://127.0.0.1:8888\",\"blacklist\":\"\"}');
INSERT INTO `t_setting` VALUES ('SMS_USED', '682265633886208', '2019-07-01 17:11:37', 0, '682265633886208', '2019-07-01 17:11:37', 'ALI_SMS');
COMMIT;

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `id` varchar(255) NOT NULL COMMENT '主键id',
  `username` varchar(255) DEFAULT NULL COMMENT '用户名',
  `nick_name` varchar(255) DEFAULT NULL COMMENT '昵称',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `mobile` varchar(255) DEFAULT NULL COMMENT '手机',
  `avatar` text COMMENT '用户头像',
  `sex` varchar(255) DEFAULT NULL COMMENT '性别',
  `status` int(11) DEFAULT NULL COMMENT '状态 默认0正常 -1拉黑',
  `type` int(11) DEFAULT NULL COMMENT '用户类型 0普通用户 1管理员',
  `department_id` varchar(255) DEFAULT NULL COMMENT '所属部门id',
  `password` varchar(255) DEFAULT NULL COMMENT '密码',
  `pass_strength` varchar(2) DEFAULT NULL COMMENT '密码强度',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '修改人',
  `del_flag` int(11) NOT NULL DEFAULT '0' COMMENT '删除标志 默认0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_user
-- ----------------------------
BEGIN;
INSERT INTO `t_user` VALUES ('164478729748221952', 'test', '测试账号', 'test@qq.com', '13720047169', 'http://www.highset.cn/avatar.jpg', '男', 0, 0, '', '$2a$10$W1JEum6b5WpdJDatn.M20evYQCISP9nsU.5YJUz8VT949rgV2vzfO', NULL, '682265633886208', '2019-07-19 11:12:06', '2019-07-19 11:12:06', '682265633886208', 0);
INSERT INTO `t_user` VALUES ('682265633886208', 'admin', '超级管理员11', 'jiabin.zhao@highset.cn', '13720047167', '', '男', 0, 1, '40322777781112832', '$2a$10$s8ilz9raFUVuWTDCLx4jtepKLl9RCrZKpv/KSj0U2PDXwIkNPGUm.', '弱', '', '2018-05-01 16:13:51', '2019-07-01 19:01:16', '682265633886208', 0);
COMMIT;

-- ----------------------------
-- Table structure for t_user_role
-- ----------------------------
DROP TABLE IF EXISTS `t_user_role`;
CREATE TABLE `t_user_role` (
  `id` varchar(255) NOT NULL COMMENT '主键id',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `del_flag` int(11) DEFAULT NULL COMMENT '删除标记',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `role_id` varchar(255) DEFAULT NULL COMMENT '角色唯一id',
  `user_id` varchar(255) DEFAULT NULL COMMENT '用户唯一id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户角色关系表';

-- ----------------------------
-- Records of t_user_role
-- ----------------------------
BEGIN;
INSERT INTO `t_user_role` VALUES ('132580108182491136', '682265633886208', '2019-04-22 10:38:22', 0, '682265633886208', '2019-04-22 10:38:22', '496138616573952', '682265633886208');
INSERT INTO `t_user_role` VALUES ('164478730486419456', '682265633886208', '2019-07-19 11:12:06', 0, '682265633886208', '2019-07-19 11:12:06', '496138616573953', '164478729748221952');
COMMIT;

-- ----------------------------
-- Table structure for t_weibo
-- ----------------------------
DROP TABLE IF EXISTS `t_weibo`;
CREATE TABLE `t_weibo` (
  `id` varchar(255) NOT NULL COMMENT '主键id',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `del_flag` int(11) DEFAULT NULL COMMENT '删除标记',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `avatar` varchar(255) DEFAULT NULL COMMENT '头像',
  `is_related` bit(1) DEFAULT NULL COMMENT '是否绑定账号 默认false',
  `open_id` varchar(255) DEFAULT NULL COMMENT '微博唯一id',
  `relate_username` varchar(255) DEFAULT NULL COMMENT '绑定用户账号',
  `username` varchar(255) DEFAULT NULL COMMENT '用户名',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='微博用户表';

SET FOREIGN_KEY_CHECKS = 1;
